Consolidate many workbooks into one workbook

[CAM]

Hello,

How do I consolidate many workbooks into one workbook. I have about 10
workbooks and I want to put it into one workbook for my user easier to
maintain. Any tips will be appreciated. Thank you in advance.


Cheers

 

[Dave Peterson]

Ron de Bruin has lots of code samples for different kinds of consolidations:
http://www.rondebruin.nl/tips.htm