Grab data from one workbook and copy to report style workbook

You could use INDEX and MATCH
For example:
B1= Lookup Criteria
Array of Data: A3:C7
Social Security Data: C3:C7

=INDEX(A3:C7,MATCH(B1,C3:C7),1)

=INDEX(A3:C7,MATCH(B1,C3:C7),1) would return first name
=INDEX(A3:C7,MATCH(B1,C3:C7),2) would return last name

An example is attached