Sorting Students Names and Attributes

Hello Everyone,

I've run into a bit of problem when trying to reference cells in different sheets. So, what I have are 20 sheets with nineteen sheets corresponding to a student (with sheet's name as the student's [with spaces]). The sheets corresponding to the individual students have the names and attributes on the same row. On the twentieth sheet I'm trying to create a column of cells of all the student's names and corresponding attributes in the adjacent columns (i.e., grades), which is essentially looking at the class as a whole. Everytime I try referencing the cells and do a copy spread action, into a column of cells in the overview sheet, from the student sheets I get a #NAME? or an Err.509.

Can some one please help me figure this conundrum out? If you need more information, please let me know.

Thank you!


Example_Spread.xlsx