Generate a list based on meeting certain criteria.

SO here is my problem i have list of students who are signed up for certain courses. Each day there are two sessions (1 and 2), for a total of ten days and sessions combined.

What i need to be able to create attendance sheets based on the classes that the kids have signed up for. I want to be able to select from the drop down menus and then have the lists automatically populated. I would also like the cells to have a border put around them so i can use them as the weekly attendance sheet. I think that is done with conditional formatting and i may have that part figured out but i cannot figure out how to get the lists to populate.

Thanks in advance for any help you gurus are able to give.

I have attached a sample sheet.

Los