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

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

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

Luke M
*Remember to click "yes" if this post helped you!*


"mike" wrote:

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