pulling multiple results from one page and putting them on another (vlookup, index match?)

Hey everyone I'm trying to put together a class roster as follows
I have the following tabs
course title (has a defined name for the list of course descriptions) with a second column of course codes
Student roster (has a list of all students with the courses they are signed up for, whether they take day, night, or mixed classes, and a grad year)

Course roster (this is what I need help with)
I want the course roster tab to let me pick from the pull down the course name and give the code for it (this part i have done)
Next I want it based on that course code to find from the student roster all of the students in that class
Then I want it to list the students with the courses they are in their class time and grad year

I'm pretty sure I've done something like this before using excel functions but for the life of me cannot remember how so any help would be appreciated
I also need it to still work even if the students have blanks in their schedules like in some of the cases

I am uploading a copy.
Course Sched.xlsx

Jbeaucaire,

Thanks that works great. Do you think this would be the best way to make any 0's blank in the results or is there something better?
=IF(IF(ROW(G4)>$C$2, "", INDEX('Student Roster'!G:G, MATCH(ROW(G4), 'Student Roster'!$K:$K, 0)))=0,"",IF(ROW(G4)>$C$2, "", INDEX('Student Roster'!G:G, MATCH(ROW(G4), 'Student Roster'!$K:$K, 0))))

Thanks again for your help

JBeaucaire,

On the students that had blanks in their class list when it got carried over to the class roster there were 0's in the blank spots on mine.