I have 13 worksheets titled Jan - Dec and Total. Each of the Jan - Dec
worksheets are set up identical but after each month, different data is
entered for that month. The Total worksheet has 12 columns titled Jan - Dec.


Total!A1 = Jan!$A$1.

Is there a way to copy the reference in Total!A1 to Total!A2 so that
Total!A2 = Feb!A$1$, Total!A3 = Mar!$A$3, etc... ????