using a cell value to determine the sheet name in a formula

[robertdseals]

Hello,
I want to use a cell value to determine what sheet is used in a formula. For instance, if I have January in cell A1 and I have a sheet in the workbook called January; I want to put a formula on another sheet that says, "look in sheet (whatever is the value of cell A1) and return the value in cell B30. Hope this makes sense.

sorry. To add more difficulty to it, the value in cell A1 is only part of the sheet name. For instance, if cell A1 has January and the sheet is named January Stats. So, the formula should look something like "=INDIRECT(B7&" Stats"&"!E3")" but that doesn't seem to work.

 

[Fluff]

How about
=INDIRECT(A1&"!B30")

 

[robertdseals]

If the sheet was named January that would work. But, because the sheet is named January Stats, that formula isn't working.

 

[Fluff]

In that case use
=INDIRECT("'"&A1&"'!B30")

 

[robertdseals]

Genius! Thanks!

 

[Fluff]

You're welcome & thanks for the feedback