In an excel workbook with one sheet showing a compilation of data from the other sheets in the book, I am unable to come up with a way to link cells in the compiled sheet to the current "moving average" values of the other sheets.
Specifically, it is to show the moving average (last four rounds) of a golfer in a single cell next to that golfer's name on a page. Each sheet in the workbook is identical and shows certain stats on the golfers. These stats are compared on the last page in the workbook.
My last name is "Happ" so here is the problem: How do I link the cell next to my name to the "current" moving average which changes each time I add another round of golf's score to the list? How do you hit a "moving target" since the moving average is a column rather than a a single cell reference?