Pivot table across multiple tabs in a workbook

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.

I've checked the resources you recommended and while learning a lot, still haven't found out how to do this.

I created a workbook to illustrate what I'm trying to do. What you'll see is that the workbook contains a Summary tab and three tabs, one for each customer. The tab columns are identical, but the rows are logs of issues.

The Summary tab is where I would put the Pivot Table. When you look into it, you'll see that I'm looking for the ability to select all or by customer and then see a list Issue Categories with counts and have the counts broken down my Importance.

For example, If the Page was set to all,

The table would have a row for "Logistics" that would show counts of 2 for High, 1 for Medium, and 3 for Low.

Another example: Page set to Acme

"Logistics" shows 1 for Low and 1 for medium.

Any idea how to do this?

I did, but I'm lost when it comes to SQL and VBA.

AlsoI don't know if this is a factor or not but this example, like so many others I've seen looks to find common entries, such as Sales and combine them into single entries in the pivot table. I'm just looking for counts - there are no fields to combine.