Why not just use
right click sheet tab>move or copy>copy>select the workbook>

Hi,

Copying one sheet in a Workbook to a another sheet in a different Workbook
using Paste Special will not display the same layout . All data will be
fillied within the deafult cell width. You must manually align the worksheet
clumns and rows to match the original layout.

To Move a sheet to a different work follow these steps:

1. Open the Workbook and click the Worksheet Tab you want to move.
2. Right-click on the Worksheet Tab and select Move or Copy. The Move or
Copy dialog is displayed.
3. Under the Move selected sheet section click the To book list.
4. In the Before sheet list, select the sheet tab before which you want to
Move or Copy the current sheet.
5. Click OK to accept the setting. Now you will find the Layout of the Sorce
file and Moved sheet will look identical.

Challa Prabhu