Do you know you can copy a worksheet from one workbook to another with a simple Drag & Drop? Here is the technique.

Steps to copy a worksheet to another workbook

1. Open 2 workbooks, the one containing the sheet to copy and the one that will receive it
2. Change the layout of workbooks so that both are visible on the screen
3. Select the sheet to copy
4. Press and hold the Control key until the end of the operation (a + icon appears)
5. Click to move the sheet to the second workbook
6. Release the mouse button, then the Control key
7. The sheet was copied to the second workbook

The steps in Video

Move a worksheet to another Workbook

The technique to move a worksheet to another workbook is similar to the previous one, except you don't press the Ctrl Key.

1. Open 2 workbooks, the one containing the sheet to copy and the one that will receive it
2. Change the layout of workbooks so that both are visible on the screen
3. Select the sheet to copy
4. Click to move the sheet to the second workbook
5. Release the mouse button, then the Control key
6. The sheet was copied to the second workbook