Dear All,
I have multiple workbooks with several worksheets included on each workbook. I need to copy each worksheet from each workbook,merge them together and copy them to a new workbook. E.G. Workbook(1) with worksheet(1),worksheet(2),etc.
     Workbook(2) with worksheet(1),worksheet(2),etc.
Copy From Workbook(1) worksheet(1) and From Workbook(2)
     worksheet(1) to the new Workbook merge them together   
     and place them at worksheet(1) of the new workbook.
The same for the worksheets(2) and etc.

Can anyone help me?

Thanks
Marinos   

hi,

This could be a VBA question that should be addressed in forum707: VBA Visual Basic for Applications (Microsoft), unless you are doing this in VB5 or VB6.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

Writing a macro to generate the code is sometimes a good start.  In the following link scroll down to the topic "How do I write code to ... ? [a.k.a. recording macro's]".

http://www.vbforums.com/showthread.php?t=391665