Question: how to copy an excel sheet to a new tab?
Answer: Simply, click on the sheet tab that you want to copy, hold the Ctrl key and drag the tab where you want it: ... 
For instance, that's how you can make a copy of Sheet1 and place it before Sheet3: ... 
To copy a sheet, go to the Home tab > Cells group, click Format, and then click Move or Copy Sheet: ... 
Note. ... 
Awesome, isn't it?