I have an accounts workbook. Each of my bank accounts is imported onto a different sheet, sadly each bank has a different format. I then add my own custom fields which gives each transactions a unique idetifier, lets me categorise each transaction (income, tax, travel expense etc), the amount of the transaction and also a notes field. These custom fields are in a standard format for each sheet.
What I would like to do is create a pivot table that pulls the data from each sheet of my custom fields, so that I get a sum of each of the catergories. I’ve looked at creating a data model and consolidating ranges but this created new fields for each sheet so I can’t get the data from across all sheets into one field in the pivot table.
Running Excel 2016 on Windows 10 Pro