Excel question

[Jayems]

Hoping someone can help me. I'm a excel rookie was hoping to do the following.

Basically, I have 20 player sheets. At the bottom of each sheet is an average number cell that will change throughout the week based on rankings. I want to create a master sheet that will only tell me the player name and correlate it with that specific player's average ranking cell and have it update automatically.

Just want to see:

John A - 52
Sam B - 44
Tom J - 55

Because I'm an excel rookie, I looked into consolidation. It's kind of doing what I want, I'm linking the cell back to the master sheet, but then it keeps adding everything up (sum). So John A will correctly display 52, but Sam B will show 96 as it's adding the two up. Tom J will show the sum of all of them. I just want it to display the average number that is on each players' sheet next to their name, but don't see an option for that.

I don't want it add them all up just show the damn number that's in that cell for each player. What the heck am I doing wrong?

[RW99]

I'd try to help, but I'm just not seeing what you are trying to do. If no one else jumps in that can help maybe add a image or two and I can take a look.

[Jayems]

Sent a PM. Thanks.

[Jayems]

RW pointed me in the right direction. I ditched consolidation and did cell reference, using =Sheet1!$A$1 as the code and I can at least get the numbers in there now.

However, I am unable to update them. I changed the numbers to see, and it didn't change. Is there a way to update all the cells? I used the update all tab and it did nothing. It tried to re-link and still the numbers remain unchanged.

[Jayems]

God I'm a rookie. I figured it all out. Thanks!

Hangs head in Excel rookiness shame. (Issue was referencing the sheet name. I had _ in there and apparently I needed to use a , in the link section thing)