Hi folks, i'm not a total newb at excel but still need help doing non-formula related work. I don't have the workbook/spreadsheet here at home so I'll just have to explain it, here goes:

I'm a teacher and I need to print individual report cards for each of my students. The students have to go through 5 different classes. Each of those classes tracks their test results on a work sheet within the workbook so 5 worksheets right. on each work sheet the students data is alwasy on the same row. so in worksheet one student Joe is on row 5 and his test results data start in cell e5 and go all the way out to m5. and so on with each student and each class.

Now I would like to be able to auto populate a worksheet with a "drop down" that lists each of the student's names so that when I select them from the drop down their information from all the other worksheets will magically appear with the appropriate titles in the column to their left on the printable work sheet.

1) How do I make the drop down list on a blank worksheet (this wold be sheet #6) in the workbook?
2) How do I make it so that their info will 'show up' when their name is selected.

If all you can provide is what the item is called I can totally read up on it.

Thanks for all the help.