Sometimes you don’t want to publish whole dashboards in Tableau Public, but a workboot with several sheets displayed as tabs above.
If you upload your workbook (only sheets, no dashboard) to Tableau Public it will display just the sheet you were currently working on.
If you want to show the other sheets as well you will have to change the settings of your published workbook. Klick on the gear icon (Settings) in the upper right corner and choose the second option “show sheets”.
The site will reload and you will see all of your sheets as tabs above. Now you can click through them to see all your different sheets.