You can't use hyperlinks on hidden sheets.
Try this code by implementing it in sheet1:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Intersect(Target, Range(Cells(12, "D"), Cells(12, "D").End(xlDown))) Is Nothing Then Exit Sub
Sheets(Target.Value).Visible = True
Whenever you double click on a sheet name in column D (row 12 and down) then the sheet will be made visible and activated.
You probably want to add another code to each individual sheet to hide the sheet again, when the sheet is deactivated for example.
Or you can hide all sheets again whenever sheet1 is selected. But that is up to you.