Is this what you mean? Right-click on the navigation bar to pop up a list of
all the visible sheets in the workbook. You can use the arrow keys and Enter
to select a sheet from this pop-up menu.

Also, you can use the navigation bar as you described; you can click on the
desired sheet tab; you can use CTRL+PAGE UP to move to the sheet to the left
of the active sheet and CTRL+PAGE DOWN to move to the sheet to the right of
the active sheet; and you could use a hyperlink or macro to move to a
different sheet. There are probably more I haven't remembered.

Hope this helps,

Hutch