Copy and Paste Data between Two Open Workbooks

I want to programmatically copy three ranges from one open workbook and paste those ranges into the same cell addresses of another open workbook. The name of the receiving workbook will vary, so I can't write its name into the code.

The code for copying the ranges looks like this:

Please Login or Register  to view this content.

This successfully puts the three ranges on the clipboard. My problem has been creating a macro on the workbook to receive the pasted material. I don't know how to write the macro to paste each range itno the corresponding cells.

Someone suggested something like this:

Please Login or Register  to view this content.

But that would only copy/paste data within a notebook.

Does anyone have any ideas? I've been at this for hours.

Thank you

You need to get the name somehow unless you make sure the destination workbook is active when the code is run. If so

Please Login or Register  to view this content.

Amend the sheet names according to requirements