Question: how to move excel sheet to another excel file with formulas?
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?