Sending monthly donor totals to year end sheet trouble

[christinejoy4music]

I am an intermediate excel user. I have created a donor spreadsheet for each month of the year. I am wanting to create a year end spreadsheet of these donations.
My monthly spreadsheets consist of First name, Last name, Initial donation, three Columns for extra donations and then the monthly total (using autoSUM).
In the year end spread sheet the first two columns are the first name and last name. then the top row is the months of the year( Monthly totals) ending with the year end total( using autoSUM).

What method would I use to send the monthly totals from the individual monthly spreadsheets to the appropriate columns in the year end spreadsheet? I have tried using =, but that is extremely time consuming. My biggest issue is that the donors are different from month to month. Some are new, and some have stopped donating.

I would love a macro that I can apply. I don't see that being possible as the donors change month to month.

 

[shinigamilight]

Carefully look at how I named my sheets. January is the sheet name and January in the top row in the yearly worksheet: That's the important part to pull data from that sheet.


CTRL SHIFT ENTER WHILE ENTERING THE FORMULA
Drag this formula across the year end worksheet
C2:

=INDEX(INDIRECT(ADDRESS(1,COUNTA(INDIRECT("'"&C$1&"'!"&"1:1")),4,1,C$1)&":"&ADDRESS(COUNTA(INDIRECT("'"&C$1&"'!"&"A:A")),COUNTA(INDIRECT("'"&C$1&"'!"&"1:1")),4,1)),MATCH($A2&$B2,INDIRECT(ADDRESS(1,1,4,1,C$1)&":"&ADDRESS(COUNTA(INDIRECT("'"&C$1&"'!"&"A:A")),1,4,1))&INDIRECT(ADDRESS(1,2,4,1,C$1)&":"&ADDRESS(COUNTA(INDIRECT("'"&C$1&"'!"&"A:A")),2,4,1)),0))

 

[christinejoy4music]

Which part of this is referencing the January sheet?