Excel 2007 : Drop-Down List & Updating Cells

I work at a small private university in the admissions office. Right now, my bosses would like me to update the way they do their contact sheets (we call them 3 sheets, since there are 3 different forms that go in each applicant's file).

I've attached examples of our Applicant and 3 Sheet files. Basically, we want a want to create a drop-down list in the applicant file to select the applicant's name. When an applicant is selected on the first sheet, then my bosses would like it if the applicant's name, Datatel (student ID) # and phone number fields on each other sheet is updated as well.

Is there any way to do this? I have already labeled the columns for those fields as "Name", "Datatel", and "Phone", but I'm not sure what to do now. Any help is greatly appreciated!!

-Myles


Example_Applicants.xlsx
Example_3Sheets_2.xlsx

Myles,

This website may help you. http://www.contextures.com/xlDataVal05.html The only problem is that you have to have both sheets open in order to do what you are looking to do.