I am trying to copy the function +'game (1)'!e9 by using the drop and
drag function. But instead of the advancing the cell number when dragging
down a column I want the game number to advance. So the cell below the
function will read +' game (2)'!e9 , then below that +'game (3)'!e9 ,
etc.... Game data is entered into a game sheet and I want the info form each
game to be automatically entered into the individual player's stat sheet
broken down by game.