I'm trying to create a personal budget. I have each payment source on its own sheet, for ease of data entry: Bank debit, Amazon, Visa, etc. And, each of these is organized with the same headers: date, description, amount, and category.
For ease of budgeting, I need to be able to pull all of these different data sets in to one large set, listing the category, and sum of amounts like the pivot tables on each sheet.
I've attached a worksheet of how the data is stored with some sample data. And, there's a pivot table on each sheet already in the format I'm looking for. I just can't seem to figure out how to get all of the data from all of the sheets culled in to one pivot table (on a new sheet)--when I do multiple consolidation ranges, I can't get the categories to list at all. I've tried using tables as well with similar results. Surely, this is something easy I'm missing.
Thanks.
Bookmarks