How to create a summary table from multiple different tabs?

[Leevi90]

Hi,

How could i create a summary tabb from all the tabs i have in the attached excel?
All the tabs have equal headers and outlook, just the data is different.

Tried to consolidate but it says "no data was consolidated"
Was thinking about pivot table and linking the tabs with the "relationship" button but somehow that didn't work either..


Would be super grateful if someone could help me out

Thanks a lot!

[MarvinP]

Hi leevi,

I believe there are multiple ways to solve your problem. Excel has a feature on the Data Tab called Consolidate that claims to do it most easily. Read:

https://support.office.com/en-us/art...5-a0b2c9e36d9b

[Leevi90]

Hi,
Thanks for your answer. I tried consolidating but it just says "no data was consolidated".Do you know what could be the problem?

Thanks in advance.

[Leevi90]

It says "consoliadation reference not valid"