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.