Working with Multiple Worksheets
When you copy a sheet, you are doing just that—making a copy. When you move a sheet, you are moving it to a new location.
To move a worksheet within the same workbook, drag the sheet tab to the new location (a small black triangle appears) and drop it. To copy it, hold down the Control key while dragging the worksheet to its new location.