Say that I have a large set of data on one sheet that contains
column 1 = names of students
column 2 = the school that they attended
column 3 = their GPA

The data is unsorted.

On another sheet I want to have various top ten lists, for example the first top ten could be top ten GPA overall sorted from highest to lowest. The second list below that would be top ten GPA for a particular school sorted from highest to lowest. Then there is another list, the bottom 10 GPA.

I want to have it so if the data in the other sheet is changed the lists in the other page all update automatically. What do you suggest I use to accomplish something like this?