Then you need to use an insertion point other than 0,0,0. That exact value will vary based on your titleblock, so you’ll have to adjust to see what the correct value is.
I believe that the same method show and discussed above will work for this, assuming:
You know the location in the reference view. I recommend just grabbing this manually once and using excel, a notepad, or a code block to keep the value consistent in a project.
Both have matching dimensions and scale. A scope box helps for this, but there are other ways.
Both title blocks have matching origins. Yes, this is a dumb thing to have to think about but you do - if either office CER started by just importing a CAD file you may find the sheet view’s origin is slightly in relation to one titleblock or another.