Permanently linking moving cells

Hi everyone, sorry if this has been posted before but it's driving me nuts trying to figure it out..

I'm trying to create a relatively simple spreadsheet to track sales information. We have a number of salespeople, and the main spreadsheet I use tracks various sales information related to their performance. this information is ranked according to sales performance, although other information is also noted. Each salesperson also has a sales manager who overseas teams of salespeople. I need a way to present this data in two ways;

1 ranking the overall performance of the salespeople
2 ranking the performance of the sales managers on a seperate page.

what i've tried to do is set up two sheet son the same spreadsheet, a master sheet with the sales people and a second page with links to the performances of the salespeople working under each manager and arranegd into groups (by sales manager). the problem is, when i set up a link between each cell or row, as soon as the order of the saels people changes the information on the second page suddenly makes no sense. Is there any way to permanently refer to a cell on another page no matter where it moves around?

I'm using excel 2007 here btw, but i'm sure it'd be the same as for 2003.

thanks!

Looks like Pivot Tables would help you out

Many thanks, that really helped. I can't believe I've gone all this time without using pivot tables.

One small problem, it seems that you can't use data on pivot tables in the same way as regular data. The problem that I have is two sets of data (goal, and money made towards goal) which I've used pivot tables to collate information from each of the sales managers (i.e. the total amount of money made towards the goal by the salespeople in each team). I now want to represent this inofrmation in a third column as a percentage. Usually I would use =SUM(B2/A2) for example, but in this case I can't use the copy down function to add a new column showing the percentages. Any ideas about how to do this?

great stuff, I'll go over this now. Thanks so much!