Index and Matches

Afternoon,

I am struggling with this spread sheet I had made. On the second sheet called Student PLC there is a box in C1 that allows you to select students from the previous sheet. However, it will not allow you to select all of the students and I do not have a clue how to expand this to include all the students.

Any help will be gratefully appreciated.

Regards