Hi Cynthia.
Go to the View ribbon and select the Page Layout View in the Workbook Views section. Click in the left, center, or right header section where you want the Sheet name to appear. Open the Header & Footer ribbon and click on the Sheet Name icon in the Header & Footer Elements section.
Here is an article on the subject. This is not a Microsoft site so use appropriate caution as with all web locations.
Quick Tip: Add worksheet name to an excel printout - Go Rainmaker