Textbox combined with dropdown menu

I looked through your forum for a while but I did not find a 100% match for what I am looking for.
I have a dropdown menu, which shows number 1,2,3,4...
What I want to achieve is the following:
If number 1 in the dropdown is selected, the textbox should link you to Excel Sheet 2 when clicking on it. If number 2 in the dropdown is selected, the textbox should link you to Excel Sheet 3 when clicking on it.
How can I achieve that? What formula needs to be inserted in the Macros that the textbox is connected to the dropdown and changes the links according to what is selected in the dropdown menu.
Thank you for your help already in advance.