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.