I'm trying to put together some data sheets I'll be using for taking volleyball stats for the team I coach. So far I've made a few tables for different stats for. Each table has several columns, all of which can be sorted.

For example, one table includes columns listing the player (starting with number 00 format for easy sorting by ascending number), earned points, errors, faults, and their "net contribution" (just a sum of the previous 3 stats). Earned points, errors and faults can all be found from other tables that have sortable "total" columns. Each table has a "total" column (right most) and row (bottom) so I can add up the totals for each player and the team as a whole, respectively. I like being able to sort each column so I can rank each player by stat. Right now I can only manually enter the data into this table, even though I can get it from another table. I'd like to format each cell in this table by referencing a cell in another table. Originally I did it the simplest way; ex- =Y37. It gave me the correct value I was looking for, as it should, but as soon as I sorted any column in any of the tables used the stats changed. I then tried modifying my formula by just adding $; ex- =$Y$37. This worked when I only sorted any of the columns in this chart, but as soon as I sorted a column in a chart I referenced the values were wrong.

My overall plan is to have one workbook for the entire season. Each sheet will contain one match, which could contain up to 3 games. All three games will utilize the same tables, most of which I will be entering values manually. As we play more matches I will add more sheets, and I want to have one sheet that adds up all the stats from all the sheets so I can see the season long stats for each player. First I need to know how to sort tables while referencing cells from other sortable tables, then I need to know how to do the same thing but reference cells from another sheet.

Any help we be great...