I have a mult-sheet workbook and am trying to make a drop-down menu to
navigate to different sheets.

I made a column with names of each sheet and in each cell i put a
hyperlink to that sheet. I was hoping that when I made that into a
drop-down it would activate the hyperlink, no such luck.

Has anyone made something similar that works?

Thanks