moving worksheets

[mike]

I have 57 different workbooks containing two worksheets each. At the end of
each month I need to move the two worksheets out of each workbook into one
new workbook and then add two new worksheets into the 57 workbooks. I do
this now by using the copy and move functions. Is there a quicker way? Is
there some sort of batch file I could use?

Thanks in advance,
Mike

 

[Luke M]

Check out Ron De Bruin's article on merging multiple workbooks:

http://msdn.microsoft.com/en-us/library/cc837974.aspx