I am trying to summarized several months of data from a credit card import into excel by vendor. Each month, the vendors may vary somewhat so there is no specific order of the vendors, month by month. How do I extract the information for each vendor, from each worksheet, to summarize it?

Thanks,