Sheet Name in a formula

[playfoot]

Likely a simply question.

I have a "changing cell", that is a cell for the user to enter in a
date. For example "Apr-04". This date also refers to Sheet within
the workbook by the same name. Down below, I have data tables,
forumlae, etc that use data from specific sheets. For example
=Apr-04!B3.

How do I make the formula so that it uses the selected date from the
changing cell to calculate. Ie, if the user selects Dec-04, then the
formula, tables, etc use =Dec04!B3 or whatever?

Thank you once again in advance.

 

[JE McGimpsey]

Likely a simply question.

I have a "changing cell", that is a cell for the user to enter in a
date. For example "Apr-04". This date also refers to Sheet within
the workbook by the same name. Down below, I have data tables,
forumlae, etc that use data from specific sheets. For example
=Apr-04!B3.

How do I make the formula so that it uses the selected date from the
changing cell to calculate. Ie, if the user selects Dec-04, then the
formula, tables, etc use =Dec04!B3 or whatever?

If your cell is, say, A1:

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

The single quotes are only necessary if your sheet names could have a
space in them.