Combining Multiple Tables in a Single Pivot Table

[crookesa]

I have a table for each month of the year on separate tabs each one named (both table and sheet) corresponding to the respective month
The tables need to be on separate sheets for usability reasons.

I want to create a pivot table which takes all 12 tables as input on one single sheet and allow me to filter based on the date in each table.
The entries on each sheet will have a working week calculated with each working week possibly have entries across 2 months.

I have tried using the pivot Table wizard by adding all 12 named ranges e.g. January, February corresponding to each table, etc...

I can't seem to get the consolidated pivot table report to look like that one I have created on each monthly sheet.

Is this possible or am I fighting a losing battle, I've tried a few tutorials on youtube, etc. but can't get it right.

 

[sandy666]

maybe use Power Query

 

[crookesa]

I'll have a look at it but my first time going into this side of things in Excel... Any tips or resources available for an intro?

 

[sandy666]

• What is PowerQuery
• Getting started with PQ
• PowerQuery Help
• PowerQuery M reference