Two things to do:
A) You want the book to open on the 'front' sheet each time.
With the workbook open, on the menu bar next to File there is an Excel logo
(green X); right click this; select View Code. In the Module window paste
this:

Private Sub Workbook_Open()
   Worksheets("Sheet1").Activate
End Sub

Change "Sheet1" to suit your need

B) You want to click a cell and have a specific sheet open
On the "Front" page, in some suitable place (mid window) type a list of
names (intrigued by term 'noun name' !) corresponding to each of your
worksheet content ( Switch, Converter, Transformer, Widget, Klystron .....)
Right click each cell in turn; select Hyperlink. On the Hyperlink dialog,
select Place in this Document on left hand panel, then in window (you may
have to wait some seconds) select the corresponding worksheet name.

Question: DO you want the user to return to the "front page"?
Add a hyperlink on each inventory page: Back to Table of Contents and
reference the "front page"

Best wishes