Hi is there a way to create a pivot table with data from multiple tabs? I am doing my taxes and I exported all my business transactions into an excel, but it has 4 different tabs as I have 4 different accounts. I created a data/drop down to categorize them on each tab. So now I want to aggregate all the categories (e.g. promotion, car, supplies, etc.) into one master summary. But not sure if I can create one master pivot table from 4 different tabs.
Help!

Thanks