SORTING NON-REFERNECED DATA

[JAY]

I have a workbook that has 2 sheets in it. the first
sheet has a list of employees(col.A), id numbers(col.b),
and start dates(col c.). The second sheet has a reference
to colA on sheet 1 to show the employee names, and
successive columns with the number of hours worked for
each employee.

How can I get the unreferenced data (number of hours
worked)to sort when I do a sort on the first sheet? The
referenced data is sorting, but the unreferenced data is
not.

Thanks.