If you want to view hidden sheets in Excel, you have to actually unhide them. This process is just as easy as hiding them in the first place.
First, right click any sheet, and once the pop-up menu appear click on Unhide…
A dialog box will appear. Click on the sheet you want to unhide, and click OK.
Now your hidden sheet is back in view.
