Create pivot table from multiple sheets

[Soizicmc]

Hello, I need help consolidating data into one pivot table, from multiple google sheets.
I enclose the google workbook. Copy of Orders 24-25
Each tabs are like a category (football, music, sports, etc).
I need to the get the data from different columns. There are multiple columns that have the same header that I need to get: AGENCIA, ENTR, TOTAL, BENEFICI
And then each category have some columns that I need to consolidate, like sub category and subsub category.
For example, for football i would need local and visitante, for music it would be the columns lloc and event (in this order), for sports: event and local...
How can I do that?
I saw in some tutorials that I need to put all data into one spreadsheet, but i just don't manage to do so with the different headers and the tables are dynamic, we will add rows along the year.

Thank you

 

[arthurbr]

Hi
why would you "prefer not to say" your XL version? It is important that we know that to offer a tailored-made solution, thus avoiding wasting our time. Thx

 

[Soizicmc]

Hi
why would you "prefer not to say" your XL version? It is important that we know that to offer a tailored-made solution, thus avoiding wasting our time. Thx

Hello @arthurbr , It is because there was not the option of google sheets, so I had to put "prefer not to say", I don't have any version of excel. Only use google sheets. How can i Modify it in my profile?

 

[arthurbr]

Perhaps a mod can help. In any case GS users usually indicate it in their thread titles so as not to waste time by the non GS savvy members ( as this is an XL forum). Good luck