Please tell me there is a way!
 

There must be a way.
I need to type the Worksheet (Tab) name in cell A1 of Worksheet "A" and
have the data from a specific cell in that Worksheet (B,C,D whatever)
returned to B1 of Worksheet "A". All the Worksheets are in the same Workbook.
The tab names will be differant, and many, depending on the Workbook and
Worksheet "A" will be copied to many Workbooks.

Please tell me there is a way!
 

=INDIRECT(A1&"!B1")

If the sheet name contains spaces you will have to use this formula

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

A1 contains the sheet name, and B1 is the cell you are referencing.

"Sparky13" wrote:

There must be a way.
I need to type the Worksheet (Tab) name in cell A1 of Worksheet "A" and
have the data from a specific cell in that Worksheet (B,C,D whatever)
returned to B1 of Worksheet "A". All the Worksheets are in the same Workbook.
The tab names will be differant, and many, depending on the Workbook and
Worksheet "A" will be copied to many Workbooks.

Please tell me there is a way!
 

Yes Yes Yes Exactly what I needed.
Thank You

"Sloth" wrote:

=INDIRECT(A1&"!B1")

If the sheet name contains spaces you will have to use this formula

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

A1 contains the sheet name, and B1 is the cell you are referencing.

"Sparky13" wrote:

There must be a way.
I need to type the Worksheet (Tab) name in cell A1 of Worksheet "A" and
have the data from a specific cell in that Worksheet (B,C,D whatever)
returned to B1 of Worksheet "A". All the Worksheets are in the same Workbook.
The tab names will be differant, and many, depending on the Workbook and
Worksheet "A" will be copied to many Workbooks.