Hi,

Consider me a raw beginner (actually I'm a little more advanced than raw beginner, but not much).

I'm looking to create a pivot table report from data that exists in multiple tabs in my workbook. The data is similarly formatted.

It is a workbook of customer issues. Each customer has its own tab. The column structure is identical, with headers on the columns, but the rows don't have headers.

For illustration purposes, each row is a customer issue. The first columns are:
  • tracking number
  • issue description
  • issue category
  • issue size
  • open or closed
  • Customer name (same as the tab name).

When I try and put a pivot table within one customer tab, It works exactly as I expected and I can get the results I'm looking for (such as count by issue category, count by issue category by issue size).

What I want, and can't figure out how to do, is to add a new summary sheet with a pivot table that does the same thing I described above, but includes the data in all the tabs. I would have the highest order sort be customer name.

Suggestions are most welcome and would be gratefully received.

Thanks,
-Mike

ps: I did a search but the closest I saw involved SQL and multiple files. I don't know SQL and was lost trying to figure this out.