You can apply the Move or Copy Sheet command to relocate or duplicate whole worksheets (also known as sheets), to other locations in the same or another workbook. You can utilise the Cut and Copy commands to relocate or replicate a section of the data to other worksheets/workbooks.
Move a worksheet within a workbook
Choose the worksheet tab, and drag it to your intended location.
Caution: When you relocate a sheet to another workbook, check any formulas or charts that specify data on that particular sheet because moving the sheet might lead to errors or create inaccurate results for your dataset. Likewise, if you move a sheet that is alluded to by 3-D references, the calculation might contain or omit data on the sheet.
Copy a worksheet in the same workbook
Press CTRL and drag the worksheet tab to the specific tab location you prefer.
- Right-click on the worksheet tab and press Move or Copy.
- Choose the Create a copy checkbox.
- Below Before sheet, click the ideal location for placing the copy.
- Select OK.