Combo Box (Drop down menu) macro

[jayers]

Hi -
Can somebody help me with a drop down menue macro.

I have a list of names on a hidden worksheet, Sheets("Student Info"), which the combo box menue lists those names.
The drop down menue is on another, Sheets("Sheet1")
When I choose a student name from the combo box (drop down menue), I would like several previously saved worksheets to open in the original workbook.

When another name is selected, I would like the students worksheets that were opened to be saved (with a date and time stamp), closed, and the new worksheets of the new student opened.

Thanks for your help - Jim Ayers