Can I use a drop down list to navigate to other spreadsheets

[djp]

I want to use a drop down list to select a spreadsheet or other location and
hyper link to it. Does anyone have any creative was to do this?

 

[JE McGimpsey]

you already can right-click the lower left-hand control (arrows to the
left of the worksheet tabs) to get a pop-up from which you can choose a
worksheet.

 

[djp]

Thanks for the input. I would like to do it from a cell in the spreadsheet.

 

[djp]

I want to use a drop down list to select a spreadsheet or other location from a cell and hyper link to it that location.