Use Dropdown with Tab Names to Change Data

[Phillycheese5]

Hi,
I have a summary tab with a dropdown containing 50 names which are identical to 50 tab names in the same file. My goal is to change the dropdown and have the formulas on the summary page pull in the data from the identically named tab.
Any suggestions would be appreciated.
Thanks,
Phillycheese

[NBVC]

You will need the INDIRECT function to reference the sheet name.

We will need to see the formula you currently have and advise us which cell carries the drop down..

[Phillycheese5]

My dropdown is in A5 on the summary tab and the table of tab names is on the same tab in cells A10:A59

The simplest formula I have is one that pulls straight from the other tab "KS": =+KS!B6
A formula I have that does a computation from data on tab "KS" is: {=PRODUCT(1+KS!B6:B8)-1}

Thank you for the quick reply

[NBVC]

=INDIRECT("'"&A5&"'!B6")

and

=PRODUCT(1+INDIRECT("'"&A5&"'!B6:B8"))-1

[Phillycheese5]

Works Great!!
Thank you very much :-)