Copy or move a worksheet by right-clicking over the appropriate sheet name and selecting Copy/Move from the drop-down list. In the "Copy or Move Worksheets" dialog follow these steps:
Select the sheet to be copied or moved in the Copy/Move selected sheets box (note that all the sheets are listed in order).
In the To workbook box the current spreadsheet is displayed. (If you would like to copy or move a sheet to a different spreadsheet, make sure the spreadsheet is already open and then select it in the To workbook box.)
All the sheets in the selected spreadsheet are listed in the Before sheet box. Select the sheet before which you want to copy or move the sheet selected in Step 1.
Choose whether to copy (duplicate without deleting the original) or move (duplicate and delete the original) by selecting either the Copy or the Move button. Copy or move as many sheets as you want while you are in the dialog.
Click on OK to close the dialog.
See also: