Combine multiple workbooks into 1 workbook w/ multiple worksheets

[buffgirl71]

I have multiple workbooks that I want to combine into one workbook,
putting each of the original workbooks into a new worksheet. Is there
some way I can do that automatically, without cutting and pasting each
workbook?

 

[Ron de Bruin]

Hi buffgirl71

You can try this
http://www.rondebruin.nl/copy3.htm

 

[buffgirl71]

Thank you, Ron - I'll definitely give it a try.