It can be done, probably with a VLOOKUP by itself, if each of the three
sprdshts have a common identifier for each row of data. That might be
the employee name, or SSN, or employee number, something like that.

Can you post a sample (no actual info, please) of each of the three
sheets? That will help folks here with a solution.