Copy and Paste from One Workbook to Another

[rbell22]

Hello,

I need to copy cells from one workbook and paste them into a different workbook. I would prefer for the destination workbook to not have to be open when the VBA is running. If that is not possible, maybe I could included an 'open Home workbook' code in the VBA?

Attached are two sample workbooks that I am using. Home is where the information is stored and Destination is where I'd like to paste the information. The Destination file will have the pasted information organized in a row/column format.

Home has roughly 250 tabs in the actual workbook that are titled with the Company Name.

Thank You so much in advance.

Rob