Move or copy the sheet to another workbook
Right click on the sheet (tab) in the workbook you want to move to another workbook and choose “Move or Copy”.
In the “To book” dropdown, select the target/destination workbook where you want to move or copy it to.
We recommend clicking the “Create a copy” checkbox.
In the “Before sheet” dropdown, select “(move to end)”, then click OK. If you receive an alert about a name conflict, just click Yes.
Update links in the new workbook
Navigate to “Data / Edit Links…” in the menu (not the ribbon).
Click the “Change Source…” button.
Navigate to the active workbook (i.e. the workbook you already have open)