Link in Excel Sheets

Other than a VBA solution, there are two options you might consider:

Option 1
Right click on the navigation arrows at the lower left, next the sheet tab and you can display a list of all sheets in the workbook

Option 2
On each of the sheets, name a single cell (say, A1) and this name will appear in the Name Box (to the left of the Formula Bar). Click the drop down arrow in the Name Box and pick the "name" you gave the cell and Excel will navigate to the sheet.

To name a cell, click once in the desired cell, then click in the Name Box and type a name, then press the Enter Key.