Merge several Excel files into one workbook?

Question

I have several Excel files with similar data, all formatted the same way. They all contain just one worksheet. I'd like to merge them all into one workbook with the data from each on it's own worksheet. Is there an easy way to do this?

Answer 1

Select the first worksheet you wish to merge.



Right click the sheet tab and select 'Move or Copy'.



Select 'New Workbook' in the 'To Book:' dropdown.



If you wish to copy the worksheet, instead of moving it, 'click the Create Copy' check box.



Click 'OK'.



A new workbook will be created and the sheet added to it. It will be the active workbook. Make note of the name of the new workbook.



Repeat the above process for each workbook, copying (or moving) to the newly created workbook.

Answer 2

In each worksheet click on the top left greyed out cell. This will select the entire work sheet. Copy the data and select a new tab in the work sheet where you want the data and paste.

Answer 3

Save one file as a workbook and copy and paste to that workbook. (xls extension). I think you can even drag it.

Frankly, I forgot how I did this! I have copied a sheet from one workbook to a new one, so that's what worked for me.

Answer 4

A VBA script and a itemizing of the documents would do it.. There are menu instructions to consolidate documents, besides the undeniable fact that it truly is not any longer meant for random documents, more desirable a handful of appropriate sheets. i'd do the VBA approach if I had to.