Macro to copy data from one worksheet and paste to another worksheet

Hopefully I coded this correctly...if not, I apologize. Still becoming familiar with the forum.

I'm not sure if this is possible, so I figured I'd ask and see. I'm attempting to create a macro to copy data from one worksheet and paste to another worksheet without having the other worksheet open. Is this possible and if so, how do I do it? Here is a shot of my macro as it stands now, however I would need to have both worksheets open in order for the macro to work correctly:

Please Login or Register  to view this content.

Hello robertmiller,

Please adhere to the Forum Rules regarding the "Wrapping of your Code".

In order to paste to a sheet, that specific sheet has to be active.