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

Kindly refer to attachment.

I want the total for each month in the different worksheets in the summary tab. The problem is that the date of corresponding months in each of the columns of each worksheet is not the same (i.e. 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.

I've tried this formula but obviously it's not working, so I need some help.

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

From here

Thanks.