I am making a basketball stats program.

I have a workbook where data is entered. In this workbook there are 31
worksheets, one for data to be entered for each game. The 31 worksheets have
all 23 players names down 2 columns on the left, and all the stat headings
across the top row.

I have another workbook that displays player stats with calculations and has
23 worksheets, one for each player. It has the 31 games listed in a column
on the left and the stat headings across the top.

I would like to link paste-link the data in worksheet1, row1 to the player 1
stat row1. The data in worksheet 1 row 2 to the player2 stat row1,
Worksheet1 row3 to player3 row1, etc. Then after game 2, paste-link the data
in worksheet2 row1 to player1 row2, worksheet2 row2 to player2 row2,
worksheet2 row3, to player3 row2 etc.

I thought I could do the first paste-link and then fill down. However, when
I do this, the cell location does not increase by 1. What is the quickest
way to do this?