[COLUMN]Match Month and Year of date Only, [ROW] row that has Text "Total" on Column A

[ron2k]

I've tried this to solve what I'm about to explain:

INDEX('Tab1'!$B$2:$BF$100,MATCH("Total",'Tab1'!$A$2:$A$100,0),MATCH(1,INDEX((MONTH('Tab1'!$B$1:$BF$1=MONTH(B1)))*(YEAR('Tab1'!$B$1:$BF$1=YEAR(B1))),0),0))

No luck... If you understand what I'm trying to do with just my sample formula, please ignore what follows and fire away your suggestion...

I have, say, 4 worksheets:
Tab1
>>>D1= Jan 2, 2007 [All proper excel dates]
>>>E1= Mar 3, 2008
>>>F1= Sep 6, 2009
>>>D2:F26 = Data in Numbers
>>>D27:F27 has totals for each column, A27="Totals"

Tab2
>>>M1: Jan 9, 2007
>>>J1: Mar 25, 2008
>>>L1: Sep 4, 2009
>>>T1: Dec 1, 2010
>>>M2:T49 = Data in Numbers
>M50:T50 has totals for each column, A50="Totals"

Tab3
>>>G1: Jan 12, 2007
>>>H1: Mar 18, 2008
>>>I1: Sep 11, 2009
>>>J1: Dec 23, 2010
>>>G2:J99 = Data in Numbers
>G100:J100 has totals for each column, A100="Totals"

Summary
>>>A2:A4 = List of Worksheets in workbook (Tab1, Tab2, etc)
>>>B1= Jan 2007 [Entered as proper date, Last day of month]
>>>C1= Mar 2008 [Entered as proper date, Last day of month]
>>>D1= Sep 2009 [Entered as proper date, Last day of month]
>>>E1= Dec 2010 [Entered as proper date, Last day of month]

So in B2:E4 in Summary worksheet I want the totals of each corresponding worksheet that occurred in that specific month. For instance in:
B2, I want the total in Tab1!D27, (Total for Month of Jan in tab1)
C2, I want the total in Tab1!E27, (Total for Month of Mar in tab1)
B3, I want the total in Tab2!M50, (Total for Month of January in tab2)
B3, I want the total in Tab2!J50, (Total for Month of Mar in tab2)

I have several tabs guys, the "Total" row and month (and year) columns are not in the same column number for each tab, and each the days are different for each month in each tab (for instance Tab 1 has Jan 2, Tab 2 has Jan 9, Tab 3 has Jan 12 all of the same year; so these three dates fall under Jan 2007 - column B in Summary worksheet. So I need help.