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

  1. Right click on the worksheet tab and select Move or Copy.

  2. Select the Create a copy checkbox.

  3. Under Before sheet, select where you want to place the copy.

  4. Select OK.


Source: Microsoft