Right click on the original sheet and select “Move or Copy”. At the top of the small window that opens up click on “Move selected sheets to book” and choose “New book” or any other workbook that is open. Select the “Create a copy” if you want to leave the original behind. This will copy all the settings of the sheet and information on the sheet to a new location.