Convert Multiple Tables into a Single Pivot Table with Power Query | Everyday Office 

Incredibly helpful, thanks!!!

Nice video. Happy co incidence that I had to do exactly this for a work related thing and I came across your video

Well done! Thank so very much, this is exactly what I have been looking for!

This helped me a lot. Thanks! How do I add new month to the existing pivot?

Thanks a lot, works!

If we have different named of tables but we want to append all data. How does PQ recognize this situation?

Is there a way to have this query and another just like it to automatically refresh when data is changed on any of the source tables.