Consolidating multisheet data

mtmconsult 

You wrote: The reason I have one sheet for each month is that the CC bank only gives the option to download statements monthly - but I will double check if there's a single sheet (yearly/time-bound) dbase option .

Even if there's not from the bank a single annual file, you still can do the copy and paste of monthly sheets and make your own single, consolidated. That would also enable you to do some year-to-year comparisons over time. But also, since what you're doing is looking at your personal banking transactions, you probably would desire to get the more timely data that monthly downloads would provide.

Yes, if I can get all on one sheet I think my skills are sufficient to the create a single Pivot.

I do this, as I think I mentioned, not just from my (checking account) bank, but also from four different credit cards, every month. They're each organized slightly differently-- some more columns than others, etc.--so I have to do some editing before combining them all into one consolidated database, but once that's done, the Pivot Table is easy.

You might also be able to use the Money-in-Excel master template that Microsoft has recently made available. My own bank uses dual-factor authentication, which precludes my using it, but it looks to have the kind of functionality--including linking with many financial institutions. https://templates.office.com/en-us/money-in-excel-tm77948210