Maybe something like this will work for you...

Z1: SheetList
Z2: Sheet1
Z3: Sheet2
etc
Z30: Sheet29

B2: Pick-a-sheet
B3: (use a Data Validation list here that is sourced to the Z2:Z30 sheet list)
C3: =HYPERLINK("#"&B3&"!A1","Click HERE to see that sheet")

Here's how to use that:
Selects a sheet from the dropdown list
Click on cell C3 to go to cell A1 of that sheet.

Note: if you need help with Data Validation, let us know.

Can you work with that?