I have a worksheet with two columns: job titles and job codes.

I have 15 other worksheets that have several columns including job code, and
I need to add the job title in a column next to the job code.

Example of 1st workbook:

Job Title Job Code
President A4000
Secretary B1200
Technical Asst D3211
etc.

Other 15 workbooks are set up like:

Job Code Score Average Total
A4000 421 321 732
D3211 320 170 642

I just need to add a column that shows Job Title next to Job Code in the 15
workbooks, pulling that data from first workbook.

Help!