Regrouping worksheets from several workbooks into a single Workbook

Hi all,

I'm using Excel 2010. Is there a fast way (formula or VBA) to regroup worksheets (into a single workbook) from a same workbook that has been distributed to different users?

Here is a simplified version of the scenario in more detail: I have a Workbook called A and it contains worksheets named 1,2,3,4,....10. I have sent the workbook to 5 different users and each of them have worked on specific worksheets of the Workbook. There's no duplicate work done any user...by that I mean, worksheets 1 to 3 have been attributed to User 1, worksheets 4 to 5 to User 2, and so on.

Now that each user has returned the workbook with their worksheets filled, I need to regroup all the 10 worksheets into a single workbook.


Is there a fast way to do this rather than copy and paste each worksheet into a new book?


cross post: http://www.ozgrid.com/forum/showthread.php?t=178723