Question: how to copy excel sheet with formulas and formatting to another workbook?
Answer: Select all the data in the worksheet. ... 
Copy all the data on the sheet by pressing CTRL+C.
Open the workbook in which you want to paste the data, then click the + in the status bar to add a new blank worksheet.