Change a sheet reference via drop down menu

[Kalamari]

Hi,

I have 50+ sheets with unique (not numbered) names.

I have a review page on sheet one with a drop down list in cell A2 of each sheet name.

I want to use the drop down list location in my formulas to link to the other sheets eg.

=Library!B2 returns B2 on the library page

But if my dropdown list in A2 shows Library then this formula does not work when I expected it to work.

=A2!B2

I thought it would see Library in the dropdown and use that in the formula.

[Keebellah]

Use hyperlinks to link to the value that is selected in the dropdown list.
I'll see if I can post a sample for you

[Kalamari]

Not sure I can see how hyperlinks would work the description I just read said they open in web pages.

[Keebellah]

When you create a hyperlink, you can either open a web page,or you can point to another document (file) or even to place in a document (a worksheet)
Read up on Excel hyperlinks or even just right click and select the option and you'll see the options.
The 'hard' part is to combine it the result of the drop-down-list selection

[Kalamari]

Nevermind found what I need.

=INDIRECT(A2&"!B2")

Cheers for the suggestions though.

[Keebellah]

Good to hear