In Excel 2007 VBA Macro:- Sumif & Maximum Date from another Sheet With Two Criteria

I have excel 2007. I have calculate sumifs & maximum date from another sheets with two criteria.
In summary sheet First criteria : Customer code which is enter in "A" column.
In summary sheet Second criteria : Series which is enter in "D2 : H2" column.

Our data records in sheet name "0910", "1011", "1112", "1213", "1314"
In above all sheet column "C" is customer code, column "S" is series, column "B" is Invoice date and quantity in column "N".

As per above i required vb macro to calculate in column "D : H" in summary sheet with two criteria customer code column "A" & series in column "D2:H2" from data record sheets

Summary sheet Calculate sumif with two criteria : (quantity calculate)
In column "D" : Calculate from sheet 0910
In column "E" : Calculate from sheet 1011
In column "F" : Calculate from sheet 1112
In column "G" : Calculate from sheet 1213
In column "H" : Calculate from sheet 1314


Secondly in summary sheet i required to calculate maximum invoice date in column "I" : "M" with same two above criteria i.e. customer code & series. (maximum invoice date)

Summary sheet calculate maximum invoice date with two criteria:
In column "I" : Calculate from sheet 0910
In column "J" : Calculate from sheet 1011
In column "K" : Calculate from sheet 1112
In column "L" : Calculate from sheet 1213
In column "M" : Calculate from sheet 1314

Right now i am calculate through excel formula. Example in summary sheet in cell "H3"
=SUMIFS('1314'!$N:$N,'1314'!$C:$C,$A3,'1314'!$S:$S, H$2)
in cell "M3"
=MAX(IF(('1314'!$C:$C=$A3)*('1314'!$S:$S=H$2),'1314 '!$B:$B))
but due to huge data record our calculation time are much more. Hence i required macro.
I have gone through search engine for similar post but i could not find out which is helpful for me. Hence i have posted new thread.
In view of the above let me know how to resolve our time factor.
File attached.