Share via

Create a pivot table from multiple tabs

Anonymous
2022-11-16T20:04:48+00:00

Hello,

I have an Excel M365 spreadsheet with about 40 tabs. The fields on the tabs are the same, but the data is different. I want to capture the data from specific cells on each tab in a pivot table. I want to create a summary table that lists the specific values from the fields on each tab and also tally the values.

I was able to create a summary table that summarized the data values, but I need more detail in the table. The summary table must include the tab name and the values from each tab. Does anyone have any idea how can I do that? Hope this makes sense.

For example:

| Tab Name | Column A | Column B | Column C | | Tab A | 1 | 2 | 3 | | --- | --- | --- | --- | | Tab B | 2 | 3 | 4 | | Tab C | 1 | 2 | 3 | | Tab D | 2 | 3 | 4 | | Total | 6 | 10 | 14 |

Thanks in advance!

Dawn

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101K Reputation points Volunteer Moderator
    2022-11-16T23:43:31+00:00
    0 comments
  2. Anonymous
    2022-11-17T03:10:38+00:00

    want to capture the data from specific cells on each tab

    consolidate multi sheets to one sheet first？

    0 comments
  3. Anonymous
    2022-11-17T16:25:00+00:00

    want to capture the data from specific cells on each tab

    consolidate multi sheets to one sheet first？

    Hi Peiyezhu,

    No, I don't want to consolidate multiple sheets into one sheet first. I just want to pull 3 rows of data from each sheet into a table to report on and analyze the data.

    0 comments