Totaling qtys from multiple tabs

[jbregman]

On the attached spreadsheet, I have several different types of structures that I am using for a project. Each structure type has its own tab, but these structures all use some of the same materials and I would like to be able to set up the fourth tab to list out all part #s that are required and to total the quantities of each part required. Is there a way to set this up to populate automatically based on changes to the quantities in the first 3 tabs?

Thanks.

[JBeaucaire]

Here's one way. I've added SUMMARY sheet and copied all the unique rows of parts into it from sheet1.

In column M I added a list of the sheet names to draw data from. I then added a dynamic name range (Insert > Name > Define) for that column called shNames that will expand itself as you add sheets to the list in column M.

Next I put in an array formula in column A to collect the QTY values from all the sheets listed in column M. It's an array, so if you ever edit this formula, press CTRL-SHIFT-ENTER to confirm the changes. If you press ENTER only the array will break and you will get an error. Try again.

You can add to this list with more unique part # rows from the other sheets until you've got one of each in the list.

[jbregman]

That's great! Thanks so much for the quick response.