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.