Formula Question

[ststern45]

Hi everyone,

Is there a way to create a formula that will do the following:

1. I have multiple worksheets
2. One of the multiple worksheets is labeled FL3C
3. In another worksheet labeled States, in cell B1 I entered the worksheet name FL3C
In cell B2 I would like to enter the following if possible:

=INDIRECT("FL3C!A1")
Question is:
Can I reference the cell B1 (FL3C) in place of FL3C!?

Thanks in advance!!

 

[vaskov17]

=indirect(b1 & "!A1")

 

[ststern45]

Thank you so much.

Works like a charm!!