How to Merge Excel Worksheets Into a Workbook

1. Open Microsoft Excel. Press and hold the 'Ctrl' key on your computer's keyboard and press the 'O' key to start the 'Open' window. Click on the first workbook you would like to open. Press and hold the 'Ctrl' key and click on the second workbook. Press the 'Open' button at the bottom right of the 'Open' window to open both workbooks.
2. Click the workbook on the bottom Windows toolbar that contains the sheet that you would like to merge. Right-click the sheet tab that you would like to move or copy. For example, right-click 'Sheet 1' tab at the bottom left of the Excel workspace to select the first sheet to merge. Click 'Move or Copy...' from the drop-down list.
3. Click the 'To Book' drop-down menu on the 'Move or Copy' window. Click on the workbook to which you want to move the worksheet. For example, if your other workbook is called 'Book1,' click on the 'Book1' workbook. Click the sheet name of where you want the sheet to appear in the new workbook from the 'Before sheet' menu. If you want your sheet to appear at the end of the workbook, click 'move to end' from the 'Before sheet' menu.
4. Check the 'Create a copy box' if you want to maintain the sheet in the current workbook. Otherwise, leave the box unchecked to move the sheet from one workbook to the other. Press the 'OK' button to move or copy the worksheet from one workbook to the other.