Require VBA working to construct the summary sheet with the help of date calculation

I have a file with so complicated and want to easy working with the helps of VBA codes.

Point-1-Construction the summary Report:-
-Automatic insert unique 'vendor' ( Col.C),Vendor name ( Col.D) and Location (Col.E) from sheet 'MBLB'.
-Put up the grand total of each vendor in Col.E to J from sheet 'MBLB' .Please refer working in B6,highlight in yellow colour.

But to prepare the perfect and final working of 'Point-1',we should consider the following factors :-

1-Col.M in 'MBLB' sheet.It will prepare with the help of "working sheet".
2-Col.N in 'MBLB' sheet.It is the date difference ( N3-M5).Please Refer the category from summary' sheet. Cell no.E4 to J4.
3-If #N/A comes the automatic put up >5 Year in col.N.Refer cell no.N5.


Can the above working be possible through VBA codes only? If yes,please help for the same to construct VBA codes.

For more clarification,please refer the attach file.

Regards