Create a list box/combo box with hyperlinks
 

I have a list of names on worksheet 1
i have a page for each name on worksheet 2
i would like to create a combo box/ list box on worksheet 2 which will show
me the names and when i click on one it will hyperlink it to that page


Thanks