Question: how to export an excel sheet?
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.