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.


--
Thank You!