Question: how do you copy tabs in excel?
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: