Question: how to copy an excel sheet with formulas and formatting?
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: