search & return items by ws name

[maijiuli]

Hello,

I have a worksheet named Summary which contains the names of every worksheet
in the workbook (stored in column A).

WorkSheet called "Summary":
Cell A2 = 1001
A3 = 1002
A4 = 1003...
A126

Worksheet called "1001":
Cell A4 = 1001 (AKA worksheet name)
Cell B4 = Employee Name
Cell C4 = SSN

Worksheet called "1002":
Cell A4 = 1002 (AKA worksheet name)
Cell B4 = Employee Name
Cell C4 = SSN

I would like to find a way to use a formula to return Employee Name and
Employee SSN from the individual workbooks to the Summary worksheet based off
the worksheet name and Column A of Summary worksheet.

 

[Elkar]

Try this in your Summary Sheet:

=INDIRECT(A2&"!B4")

This will give you the Employee Name from the Sheet whose name is stored in
cell A2. Replace B4 with C4 to get the SSN.

HTH,
Elkar

 

[maijiuli]

You're a genius!
--
Thank You!

Try this in your Summary Sheet:

=INDIRECT(A2&"!B4")

This will give you the Employee Name from the Sheet whose name is stored in
cell A2. Replace B4 with C4 to get the SSN.

HTH,
Elkar