combine multiple excel files into one

When you right-click on a tab and select Move or Copy you can move or copy the sheet to a new or other workbook. By repeating this action on all the sheets you want to join into one book you can create a new book containing all the sheets.

How to merge two Excel files into one by copying sheets

If you have just a couple of Excel files to merge, you can copy or move sheets from one file to another manually. Hers's how:

• Open the workbooks you wish to combine.
• Select the worksheets in the source workbook that you want to copy to the main workbook.
• To select multiple sheets, use one of the following techniques:
• To select adjacent sheets, click on the first sheet tab that you want to copy, press, and hold the Shift key, and then click on the last sheet tab. This will select all worksheets in between.
• To select non-adjacent sheets, hold the Ctrl key and click on each sheet tab individually.
• With all worksheets selected, right click on any of the selected tabs, and then click Move or Copy
• In the Move or Copy dialog box, do the following:
• From the Move selected sheets to the book drop-down list, select the target workbook into which you want to merge other files.
• Specify where exactly the copied sheet tabs should be inserted. In our case, we choose the move to end option.
• Select the Create a copy box if you want the original worksheets to remain in the source file.
• Click OK to finish the merge process.

Let me know if this helps.

Regards,
Jerry