Here's the formula i currently have on my 'summary' page

=SUMPRODUCT((SHEET3!F2:F31<=TODAY()-1)+0)

it works just fine and dandy but the problem is, when we add another line to SHEET2(or 3 or 4), the formula wont update, so we have to change it manually to keep checking the new line as well (it still checks f2:f31 but now there's data in f32 as well, which it doesn't check)... what i was trying to do, is make the [F31] portion auto update based on the cell F8 of the SUMMARY, here's what the formula looks like, i dont know the proper terms to get it to 'compute'... all help is appreciated 
=SUMPRODUCT((VEG!F2:value(Summary!CONCATENATE("F",C8+1))<=TODAY()-1)+0)
(The c8+1 is because there's a Header row above which the formula in C8 does not count )

I've attached a sample-copy of the spreadsheet in question:

SumproductIssue.xlsx