If you need to make a copy of a worksheet, rather than copying and pasting you could…
- Right click on the worksheet tab
- Select Move or Copy from the list and a dialogue box will appear.
- Select where you want the sheet to be positioned
- Click in the check box beside Create a copy
- Click OK