It's not apparent from your workbook where the date ranges on your various tabs are supposed to come from. One can guess that they're in column C for the CDs & IRAs tabs, but there's nothing equivalent on the Savings-Checking-Money Market tab or the Annuity tab.
Assuming column C is to be used for the CDs & IRAs tabs, a workable formula for those in B2 of Total EOM worksheet might be:
Code:
=SUMPRODUCT((CDs!$C$1:$C$12>DATE(B$1,ROW()-1,0))*(CDs!$C$1:$C$12<=DATE(B$1,ROW(),0)),CDs!$E$1:$E$12)+SUMPRODUCT((IRAs!$C$1:$C$12>DATE(B$1,ROW()-1,0))*(IRAs!$C$1:$C$12<=DATE(B$1,ROW(),0)),IRAs!$E$1:$E$12)
which can be copied down to row 13 and across to column L.