How to merge various workbooks into 1 worksheet in Excel

[Sharm]

I am attempting to merge data from different workbooks (at least 10) to 1
worksheet (which will act as a central depository)

 

[Anne Troy]

Are the workbooks all the same? You can try this:
http://vbaexpress.com/kb/getarticle.php?kb_id=221
************
Anne Troy
www.OfficeArticles.com