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.

Thanks for reply. That ok for limited data record & customer. But my problem is i have almost 4000 customer and in data data record sheet i have almost 40000 + record.
But i would like to inform you that, at a glance to find out who's customer buying & how much quantity & what is maximum date (latest purchase date). After that i will trap out those customer who is not buying since before 6 months.

1) Yes but it will take long period time to calculate. Hence required macro.
2) Yes.
3) As per your solutions we find out max date of customer at same time don't find min date customers.

Oeldere Sir, The solution works fine.
1) Actually not a min date. I refer less data (as per your sample solution file) Due to that i am little bit confuse. But not i refer our main file & problem resolved.
2) yes
3) Yes upgrade profile.
I am curious about vb macro. Hence i required macro to calculate fast rather than using formula's. I am not much more familiar with vb.
I have changed little bit. Attach file.
pivot.jpg