I suspect that each instance of Excel is unaware of the other, so the
Paste operation is in effect coming from an outside source.

Do you need to run the workbooks in separate instances of Excel?