If you want to move a worksheet from one workbook to another open workbook, here’s how it’s done:

1. Open the first workbook. Then do File – Open the second workbook. Do not use Windows Explorer to open the second workbook.
2. Right-click the worksheet tab and choose “Move or Copy…”.
3. Click the “To book” drop-down and the name of the second workbook should be listed.  Click on the second workbook name.
4. Where it says “Before sheet:”, click (move to end) to add another worksheet tab at the end of the other workbook.
5. Click the “Create a copy” button to create a copy.
6. Click OK.

   Hope that helps!