Excel 2007 : summarize multiple sheets within one workbook

I have been trying to find a way to summarize all sheets to one workbook. Example, Workbook 1 has 53 tabs labeled "wk1,wk2,wk3, etc. Withing those sheets I have payroll data. The name in each sheet will not be in the same row, it will change. I've tried this ,=SUMPRODUCT(--(THREED(WK1:'WK53'!$D$13:$D$100)="JOHN DOE"), THREED(WK1:'WK53'!F$13:F$100)), and I did get it to work, however it was not auto calculating after new data was entered, couldn't figure that out. I do need the formula to look through all sheets and look for a "name" and return the subtotal to a summary sheet.. Thanks!