Question: how to save excel with multiple sheets?
Answer: Right-click the worksheet name tab.
Click select Move or Copy.
Click on the Move selected sheets to Book drop-down menu. Select (new book).
Click OK. Your new workbook opens with your moved worksheet. ... 
Click File > Save in your new workbook.