Question: how do you copy excel sheet to another workbook with formulas?
Answer: Press Ctrl + ` or click the Show Formula icon under the FORMULAS tab. ... 
Select cells with formulas to be copied, and copy them by pressing the Ctrl + C keys or the right-click menu.