March 18, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is there a way to make a pivot table out of multiple tabs?

I was handed a spreadsheet with multiple tabs and asked to make a pivot table that combines all these tabs.

The tabs all have identical layouts, but with different amounts of rows, could be 21 items on a tab, or it could be 60, etc

There are header and footer rows in each tab, but I would only want to pivot the data I've highlighted in the screenshot.

Is there an easy way to do this?

Check out the full article on the original site

#rows.com

#Excel alternatives for data analysis

#financial modeling with spreadsheets

#big data management in spreadsheets

#modern spreadsheet innovations

#machine learning in spreadsheet applications

#generative AI for data analysis

#enterprise-level spreadsheet solutions

#digital transformation in spreadsheet software

#conversational data analysis

#Excel compatibility

#collaborative spreadsheet tools

#AI-driven spreadsheet solutions

#cloud-based spreadsheet applications

#real-time data collaboration

#automation in spreadsheet workflows

#intelligent data visualization

#no-code spreadsheet solutions

#AI-powered spreadsheet

#data visualization tools