Combination from .xls using unique identifier

Hello,

I have 2 worksheets each with employee information. 1 has all new employees in a time period, and the other contains their personal details (master). The common identifier for these employees is their SSN (in both worksheets).

I want to extract a list from the master worksheet (with all related data) of all those new employees and write them to another sheet.

I'm using excel 2007, but also need the process for a colleague on 2003.

Thank you in advance