In Google Sheets, you can use the "Duplicate" command to make a copy of the sheet with the contents. This is the same as the "Move or Copy" command in Microsoft Excel.
Step 1: Open the workbook and right-click the tab name;
Step 2: Click the "Duplicate" from the dialog box;
Step 3: The new sheet will appear after the original sheet;
Step 4: To rename the sheet, you can right-click on the tab name and select "Rename" from the dialog box;
Step 5: Type the new name of the new sheet.
Step 6: Please note that when you click "Duplicate", you create a new sheet within the same workbook. To copy the sheet to another existing workbook or make it as a new workbook, please use the "Copy to" command. You can make the spreadsheet to
– a new spreadsheet when clicking "New spreadsheet"; or
– a sheet within the existing spreadsheet when clicking "Existing spreadsheet".
Step 7: To delete a sheet, right-click on the tab name and click "Delete" from the dialog box.