Combining tables from multiple sheets

Good afternoon,

I'm using excel 2013 and have a basic understanding of Pivot Tables and Tables in excel but have a long way to go!

I've recorded my spending in excel. I have a different sheet for each month, with the data recorded in a table and a pivot table summarising the totals.

Is there a way I can get excel to combine all this information for me onto 1 table that shows my trends across the months? I've seen some videos on consolidating data but it all seems to be combining info using a primary key to create relationships and that doesn't apply here.

Anyone able to help?

You can load the various months to Power Query. Append each month to the other. Close and Load the data back to Excel Native and then create your pivot tables. Here is one tutorial. There are lots of others out there.

https://www.spreadsheetweb.com/how-t...ltiple-sheets/

Instead of loading the tables directly into excel, grab them from the source and when you load and close, do it to connection only. In this manner, you have not created new tables in your workbook. You may want to pick up the book "M is for (Data) Monkey" by Ken Puls and Miguel Escobar. Available on Amazon.