You can use the Move or Copy Sheet command to move or copy entire worksheets (also known as sheets), to other locations in the same or a different workbook. You can use the Cut and Copy commands to move or copy a portion of the data to other worksheets or workbooks.
Move a worksheet within a workbook
-
Select the worksheet tab, and drag it to where you want it.
Note: Be aware that calculations or charts that are based on worksheet data might become inaccurate if you move the worksheet.
Copy a worksheet in the same workbook
-
Press CTRL and drag the worksheet tab to the tab location you want.
OR
-
Right click on the worksheet tab and select Move or Copy.
-
Select the Create a copy checkbox.
-
Under Before sheet, select where you want to place the copy.
-
Select OK.
Source: Microsoft