Question: how to duplicate an excel sheet with formulas?
Answer: Select the cell containing the formula that you want to copy.
In the Clipboard group of the Home tab, click Copy.
Do one of the following: ... 
Verify that the cell references in the formula produce the result that you want. ... 
Select the cell that contains the formula.