How can we save single sheet separately from a multi page data sheet excel file?

Click Enterprise > Import/Export > Export Range to File.

Using the Move or Copy command will help you export or copy one or several worksheets to a new workbook quickly.

Step 1: Select the worksheet names in tab bar. You can select multiple with holding down Ctrl key or shift key.

Step 2: Right click the worksheet name, and click the Move or Copy from context menu.

Step 3: In Move or Copy dialog box, select the (new book) item from the drop down list of Move selected sheets to book.

Step 4: Then click OK, now you have switched to the new workbook with exported or copied worksheets, click File > Save to save the new workbook.

Note: In the Move or Copy dialog box, there is a Create a copy option. If you do not check it, it will move the selected worksheets out of original workbook; if check it, it will copy selected worksheets.

Right Click on the sheet you want to save - Move Or Copy - From To Book Choose new book & on your lower left Select Create a copy - Click Ok. 

1. Open the sheet you want to save

2. Press right click and choose "move or copy"

3. "to book" choose new book

4. put check mark on "create copy"

5. then click "okay"

You can save worksheets as PDF easily with Save as command if you are using Excel 2010 or Excel 2007 SP2. However, you may only want to save or export selected ranges as PDF, or save the whole workbook but not only current worksheet as PDF. How will deal with it?

Of course, you can copy selected ranges to a new worksheet and save it as PDF file; or save each worksheet separately as PDF files. But here we will show you a tricky way to save selections or entire workbook as one PDF file in Microsoft Excel 2007 and 2010 quickly, and save multiple workbooks in a specified folder to separated PDF files at once.

Easily save selection as PDF file in Excel

Click Enterprise > Import/Export > Export Range to File. The Kutools for Excel's Export Range to File utility helps you easily export selection as PDF file in Excel. 

source: https://www.extendoffice.com

I agree with answers of the experts .

move to other work sheet then save it

YES I AM IS ONE SINGLE PORTARAT AND THEY WILL SAVE THEM SELVES.