You can use the INDIRECT function. Something like

=INDIRECT("'"&C3&"'!A1")

will return the value from cell A1 on the sheet whose name is in cell C3.
Pay attention to the quotes and apostrophes in the formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)


"TR" wrote in message
...
I have this question for a long while.

Is that possible to choose data from Sheet1, Sheet2... based on different
conditions? Say, I have market data from Chicago, LA and NYC, each on a
separate sheet, respectively. Can I build a toggle in a summary sheet and
select "Market" and retrieve market data from these markets individually?

Thanks!