Hi all: I am using a spreadsheet with the following formula:

=(SUMPRODUCT(LOOKUP(ROW(INDIRECT($B$3&":"&EOMONTH($B$3,0)))+6,'[Weekly Report CJNH.xlsx]CJNH 2011'!$4:$4,'[Weekly Report CJNH.xlsx]CJNH 2011'!107:107))/7)
It works brilliantly, except for one issue: If I need to insert or remove a row in the CJNH 2011 spreadsheet, which I often have to do, the formula does not change. Is there a way (perhaps using match) to alert the formula so that the formulas reflect changes made to rows? Thanks in advance.