sorting

[Guest]

I have a workbook with 6 worksheets. I enter employee names and salary on the 6th worksheet(which I keep hidden) and then I have the other 5 worksheets pull the names and salary off of the 6th page in columns A:C. When I add new employees I sort them alphabetically on the 6th page this in return sorts them on all pages. In columns D:J on the other 5 pages(one page per week) I enter the hours they work each day. How can I make sure that when the names are sorted the hours are sorted with it. I'm only sorting on page 6 and on page 6 I don't have the other columns.