Moving Worksheets Between Workbooks

Method 1: Using Move or Copy

1. Open both the source workbook that contains worksheets to be moved or copied and the destination workbook where the worksheets will be placed. You need to open both the source and destination to copy or move worksheets between them.
2. On the View tab, use the Arrange All command to arrange the windows side-by-side, preferably using the Vertical option.
3. Click on the workbook with the worksheets that need to be moved or copied to activate it. Next, click on the sheet tab at the bottom of the screen to select it (to select more than one worksheet, hold down the Ctrl key as you click on the individual sheet tabs).
4. On the Home tab, click on the Format button and select Move or Copy Sheet… from the menu. This displays the Move or Copy dialog box.
5. In the Move or Copy dialog box, select the destination workbook in the To Book field. In the Before sheet field select where you want to place the worksheet inside the destination workbook.
   To create a copy of the worksheet, rather than move it, select the Create a copy checkbox.
   
6. Click OK to complete the move or copy action and close the dialog box.

Method 2: Using Drag and Drop

Just as you can copy data in a range between workbooks using drag-and-drop, you can also move or copy worksheets between workbooks using drag-and-drop.

To move or copy worksheets between workbooks using drag-and-drop do the following:

1. Arrange the workbooks side-by-side so that you can see both on the screen. You can do this manually or use the Arrange All command described above. Preferably you should arrange them vertically.
2. Click on the sheet tab in the destination workbook to select the worksheet to be moved or copied (to select more than one, hold down the Ctrl key as you click on the individual sheet tabs).
3. Drag the sheet from the source workbook across to the destination workbook with your mouse. You’ll see a little document icon representing the sheet you’re moving.
   Note : To copy the sheet (instead of moving it), hold down the Ctrl key as you drag the sheet from the source workbook to the destination workbook. The document icon will have a plus sign (+) if you’re copying the sheet.
4. At the destination workbook, you’ll see a small arrow, indicating where the sheet would be placed. You can move this arrow left and right to choose where you want to place the sheet before releasing the mouse button to place the sheet there.

This is a much faster way to move or copy worksheets between two open workbooks.