Deleting a sheet removes it from the workbook. To delete the active sheet, right-click the sheet in the sheet tab along the bottom of the workbook and select Delete Sheet. Worksheets used in a dashboard or story cannot be deleted, but they can be hidden. See Hiding and Showing Worksheets.
There must always be at least one worksheet in a workbook.