Copying formulas and possibly simplify

I have a worksheet that is filled with data from another worksheet. The data in the worksheet I am having issues with has to be broke down by month and year.

=SUMPRODUCT(--(JETRecordTracking.xls!Call_Initiator=MID(C1,5,LEN(C1))),(--(MONTH(JETRecordTracking.xls!Date_of_Call)='JET Data Tracking'!A2)),(--(YEAR(JETRecordTracking.xls!Date_of_Call)='JET Data Tracking'!B2)))

I have attached an image of the spreadsheet to help visualize this so I hope that helps.

I find the Call Initiator from the string in C2, the month from A2 and the Year from B2. Then for each month of the year I need to be able to change only the month and year (or column C). Then I need to change the Call Initiator based on Row 1, column whatever. If I copy and paste each single cell I still have to go back and edit each formula. If I try to fill the data, all three variable locations change...that does not work for me either. What I am looking for is this, is it possible to change this formula to vba to complete what I am looking for? If it was just these 9 columns (144 cells) it would not be too terrible but it would still suck...but I have other data that works in much the same way and would require very similar formulas for 85 columns (or 1360 cells).

Thanks in advance,

Dan

Sweep,

Thanks for the quick reply. I have tried that for two columns and it work great. I still am having to change the column for cal initiator but it is much better than before.

I am still open to other ideas though,

Dan