I'm using MS Office Professional 2003.
I am frequently required to compile mailing lists from Excel spreadsheets
containing extensive employee data.

Situation:
I have 2 worksheets in 1 workbook

Sheet 1 has ID#, last name, first name, address1, address2, city, state, zip
for all employees (~1000)

Sheet 2 has ID#, last name, first name of employees receiving award letter
(~200)

How do I lookup and retrieve address information for award letter recipients
from Sheet 1 and have that information correctly match and populate
horizontally across cells in Sheet 2?

EX:
Sheet 1
Col A Col B Col C Col D Col E Col F
Col G Col H
12345 Jones David 465 Main St. #1 Toledo OH
55555
25283 Baker Linda 7324 Elm St. Stamford CT
55555


Sheet 2
Col A Col B Col C Col D Col E Col F
Col G Col H
12345 Jones David
25283 Baker Linda

Thank you in advance!