If you have multiple sheets, you can move a sheet. If you move the first sheet location to the last sheet location, then the other sheets are moved to the left. If you move from one sheet to a sheet next to it, then this behaves in a manner similar to a swap. Moving a sheet does not change the sheet name.
The AllowSheetMove property of the DataBook can be set to True to allow the user to move the sheets using the sheet tabs. See Property Page for more details.
You can also hide a sheet. For more information, refer to Showing or Hiding a Sheet