If you right click the arrows on the left of the sheet tabs at the bottom, left of the Excel screen you can see a list of all the sheets in the file. You can use VBA to show this list anywhere.
The command to show this list is a one liner.
Sub ShowSheets() Application.CommandBars("Workbook tabs").ShowPopup End Sub
This list that displays allows you to navigate to any sheet in the file. Only visible sheets are listed.
You can assign this macro to a button, an image or an icon. You can even use a Quick Access Toolbar icon. See below for examples.
You can also add a keyboard shortcut – I used Ctrl + Shift + Q.
Press Alt + F8 and select the macro. Click the Options button and in the dialog that opens set up the keyboard shortcut.
Once created you can use the shortcut with a cell selected.
As you can see a simple line of VBA code offers fast navigation at the click of a button or the press of a keyboard shortcut.