Video: Move or copy worksheets
You can move or copy a worksheet in the same workbook to organize your workbook exactly how you want.
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 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.