Hello friends

I have two sheets as follows

The first sheet contains Names of Employees of about 600 employees

The second sheet contains Names and Employee Number of 1000 employees which also includes the above 600.

I want to add a new column in the firs sheet as Employee Number and want to export the data against each of the 600 employees. How do I do this ?