I have student information on two sheets, attendance and testing information.
Students' names and numbers are only entered on the testing info. sheet, but
are referenced on the other sheet. Students' status is entered on the
attendance sheet and reference on the other. Just in case it would make it
any easier to sort, I've made the row numbers on both sheets the same for
each student.

Is there a way to group the two sheets and sort the rows simultaneously, so
the cell references don't get out of order? I would appreciate any advice on
this complicated sorting problem.

Here are the basic sheet setups
*Refers to sheet 1
**Refers to sheet 2

SHEET1
A B,C D...P Q
R S....IV
Number** Name** Attendence Sums Progress** Status Hours/Date

SHEET2
A B C,D E F........
Status* Number Name Progress TestingScores


Thank you for your help!