Help with multiple tabs and one Pivot table

[jimmyr]

Hi all, I have a workbook that has 30 tabs, one for each day of the month.

All of the columns headers are exactly the same on each tab with their own day-to-day data within them.

What I need is a way for all the tabs to easily update a master pivot table. Thank you.

 

[GlennUK]

I have used this method previously ... from Debra Dalgleish: Excel Pivot Table Multiple Consolidation Ranges