>>On Mice Herding I seldom have advice - sorry, I'm an old-style keyboard punisher...
>>
>>Ctrl-C Ctrl-V works on my old '97 Excel copying from one sheet to another in the same workbook.
>>Referencing in such cases via indirect() and name of specific source sheet for that particular sheet in a cell
>>But I am very far from Excel expert - I know just a few tricks and usually can bend the problem around them.
>>Sometimes gets wonder at the speed I arrive at usable approx, but also often critique and hints of what I should do to make easier, more bla bla - before going that route I move data into tables ;-)
>
>It might have changed from versions to versions.
>
>When I used the drag and drop from the original workbook, into another workbook, and then into the original workbook new sheet, it worked.

Dunno if you're willing to try anything else... Once you've copied your source range, you could try Paste Special (Ctrl-Alt-V) rather than just Paste (Ctrl-V). This gives more options.