Question: how to copy excel sheet of one file to another excel file keeping formula working?
Answer: Open the source and the target workbook. ...  In the source workbook, navigate to the sheet you want to copy or move. Click the Home tab and then click the Format dropdown in the Cells group.