referring to a cell on another sheet based on contents of a cell

[AngieWilson]

Hi, if I have a series of sheets say A,B,C and another one called overview. If I add the sheet names to column A of overview
could I make something link what's in cell B1 below work to refer to cell B2 in sheet A?

A B
1 A =[text in A1]!B2
2 B
3 C

Thanks

 

[Jeffrey Mahoney]

Try this
=INDIRECT("'"&A1&"'!"&"B2",TRUE)
The reason you have to put the ' marks is because of sheet names with spaces. If there are no spaces in the name, excel ignores them.