Dynamic hyperlinks to other sheets within workbook?

Hi all,

Description:
I have a "results" tab that lists a ranking of several options. Each option has its own dedicated worksheet within the same workbook. Rankings can change depending on a user's inputs (found on a separate sheet).

Objective:
I'd like to have hyperlinks to the individual option sheets dynamically update as a user changes his preferences and thus, changing rankings.

Question:
Does anyone know how to do this without VBA (highly preferred)? With VBA?

Thanks!