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?