Copying data form source workbook to multiple destinations

[davidm_uk]

I have a macro in which I have a source workbook containing the macro, and data in a sheet called REF.
The macro has created a series of destination workbooks (saved as CSV files but still open) each with one worksheet with the same name as the workbook eg dest1, dest2, dest3, etc.

I'm planning on copying the data using an expression like:

Please Login or Register  to view this content.

rather than doings lots of activating and selecting, which I could probably work out by recording some macros. So far I've got:

Please Login or Register  to view this content.

that final expression will end up wrapped in various loops to define the a-c variables, but before I get to that I need to know how to define (Dim and Set) source, dest and outsheet (outsheet will also be varied to point to the output files).

If someone could help with this bit I'd be grateful.

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[davidm_uk]

Not solved, but since no replies I'm looking at other ways of doing it (see more recent question posted).