Creating a Digital Data Wall....help?

My first post...thanks for your patience as I explain:

I have a spreadsheet with 80+ student names in column A. Column B will record their reading level.
Depending on the score, I want it to automatically place the student name into one of three other worksheets. Example: If cell A1 is Bobby and his score is 25 in B1, I want his name to go to sheet2 (very low).
Sally is in A2 but her score in B2 is 60, so her name needs to shoot into sheet3 (average).
Seth is in A3 and his score in B3 is 90, so his name needs to automatically shoot into sheet4 (High).

So, when I've completed entering all the scores, each page will be populated with the student names who's scores fall in a given range of scores.

Suggestions on how to do this?

Thanks in advance.

Hi

Sheet Mark

Column C

Formula:

Please Login or Register  to view this content.

copy down
You can change those number > {0,60,90} Sample change 90 to 85!!
0 to 60 is Low, 60 to 90 is Average 90+ is high

Sheet High

Formula:

Please Login or Register  to view this content.

This is array formula Press same time Ctrl+Shift+Enter, NOT ENTER then copy down and cross.
See this > Marks!$C$3:$C$200<>"A") Next sheet average change "A" to "B" Press Ctrl+Shift+Enter then copy down and cross.
Do the same to Sheet Low "B" to "C"

See the file!

Regard
micope21

Or you can use a pivot table