Your workbook layout, with separate sheets for different periods, makes summarizing anything more difficult than it need be. For summarizing, the data ought be on a single sheet to begin with.



Furthermore, since the vendor data includes apparently extraneous content, e.g.:
GOOGLE *ADWS6276120798 GOOGLE *Google Storage GOOGLE.GOOGLE *Music GOOGLE.
getting vendor aggregations isn't straight-forward, either.

Finally, your Summary sheet implies you want a separate entry for each transaction, in which case you may as well just put all the transactions on a single sheet and sort it by vendor or by date, according to what your requirements are at the time.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]