Hi @SECOJOSE. Going by the code example you showed, with the fact that you want this to be a 'per sheet' scenario, one problem comes to mind. The drawing only has one iProperty named 'Description', so if you try to write a different value to that one iProperty per each sheet of the drawing, only the last value will be kept, because it will keep getting overwritten.
However, since I may still not be understanding something properly, I will mention something else that you may find interesting or useful in this area. The DrawingView Inventor API object has a fairly new (added in 2023 version of Inventor) property (DrawingView.IsTextPropertySource). That can only be set to True when the DrawingView is a 'base view'. When set to True, that means that the model document being 'directly' referenced by that view, on that sheet, will be the 'default source model' for any annotations on that sheet that are 'linked' to 'the model'. However, I believe this only effects those user interface tools within the Format Text dialog, where you can drop links to model data into your annotations. I do not think this will have any effect on if you are accessing these things by code. Before 2023, the first view of the first model that was placed in the whole drawing, was used as the 'default source model' for all 'linked' properties in all annotations in the whole drawing.
So, since there is only one 'Description' iProperty for the whole drawing, stored at the drawing document level, then where is the description of the model being referenced within the first view on each sheet supposed to be stored? If you think I am still not understanding something correctly, then maybe some screen captured images would help, and maybe explaining the manual steps you are currently taking in as much detail as possible, would help explain this situation better.
Below is some example iLogic rule code which will get the current drawing, active sheet, first view on that sheet (if any), then its referenced document. Then it will get the 'Description' iProperty value from that referenced document, and set that as the value of the drawing document's main 'Description' iProperty. There is no PropertySet owned by the drawing per sheet of a drawing though.
Dim oDDoc As DrawingDocument = TryCast(ThisDoc.Document, Inventor.DrawingDocument)
If oDDoc Is Nothing Then Return
Dim oSheet As Inventor.Sheet = oDDoc.ActiveSheet
If oSheet.DrawingViews.Count = 0 Then Return
Dim oView As DrawingView = oSheet.DrawingViews.Item(1)
Dim oViewDoc As Document = oView.ReferencedDocumentDescriptor.ReferencedDocument
Dim sModelDesc As String = oViewDoc.PropertySets.Item(3).Item(14).Value 'Description iProperty
oDDoc.PropertySets.Item(3).Item(14).Value = sModelDesc
Wesley Crihfield

(Not an Autodesk Employee)