Combine multiple workbooks into one workbook

Y

YM TEO

I have about 24 different workbooks which had a different worksheet,
maintained by different users.

Some time to analysis the data, I have to open up all the workbooks and move
the worksheet over manual to form an new workbook.

Is there a command which will copy the data over from each worksheet to one
master workbook, with 24 dofferent worksheets?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
Help on consolidate worksheets from different workbooks into one 2
consolidate workbooks to worksheets in one workbook? 1
Collate Worksheets into single workbook 3
Multiple workbooks to one worksheet 3
Copy cells from 4 w'sheets in multiple w'books to 1 w'sheet in 1 w'book 0
Multiple Workbooks into One? 2
multiple workbooks in one file 3

Top