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

"Sharm" wrote in message
...
I am attempting to merge data from different workbooks (at least 10) to 1
worksheet (which will act as a central depository)