Combine total items

Good day all,

I have a problem and I need an Excel expert`s help.

In an excel sheet, I have several sheets. In every page I have several items.
Many items are repeated in many sheets. Here is an example:

PM Kit for WEPA system includes these parts
- PPP x (quantity) 2
- OOO x 3
- VVV x 1

PM Kit for ZENI system includes the following parts:

- PPP x 4
- OOO x 1
- VVV x 1

What I would like to do is to find a way to know the total of PPP (2+4) other than opening every sheet and counting them manually.

I have 63 pages and some items are present in more than half of the pages.

This causes me a loss of time.

Please help me.

Thank you.

Vishesh's picture

Since you have 63 sheets in

Since you have 63 sheets in your workbook; so a macro should solve it. Please upload a sample file.