Spreadsheet: 694208d1599442649-condensing-down-like-items-in-a-material-list-example_updated3
Sheet: example

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | These rows are over multiple sheets |  |  |  |  |  |  |  |  | this is combined on one sheet but would like all like items to be condensed before the final list on a separate sheet |  |  |  |  |  | showing what QTY needs to be adjusted
 |  |  |  | data validation list | data validation list | data validation list |  |  |  | Intermediate list
 |  |  |  |  |  |  |  |  |  | Item | Qty | Size | Color | Material Type |  |  |  |  |  | Item | Qty | Size | Color | Material Type
 |  | Top Bolt | 51 | 1-3/4" | black | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  |  |  | Top Bolt | 51 | 1-3/4" | black | Stainless Steel | combined with other black
 |  | [NAME] | 61 | 1" | black | Alloy Steel |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 61 | 1" | black | Alloy Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle Bolt | 4 | 1-1/2" | red | Stainless Steel | combined with other red
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Right Bolt | 12 | 2" | red | Zinc Plated
 |  | Middle Bolt | 4 | 1-1/2" | red | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outside Bolt | 18 | 1-3/4" | black | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt1 | 1 | 1" | green | Stainless Steel | combined with other green
 |  | Right Bolt | 12 | 2" | red | Zinc Plated |  |  |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt2 | 4 | 1" | red | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt3 | 31 | 1" | green | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt4 | 4 | 1" | green | Stainless Steel
 |  | Left Bolt | 0 | 1" | green | Alloy Steel |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt1 | 16 | 1-1/2" | red | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt2 | 8 | 1" | silver | Stainless Steel | combine with other blue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt3 | 4 | 1" | silver | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt4 | 16 | 1" | silver | Stainless Steel
 |  | Outside Bolt | 18 | 1-3/4" | black | Stainless Steel
 |  | Inside Bolt1 | 1 | 1" | green | Stainless Steel |  |  |  | Item | Qty | Size | Color | Material Type
 |  | Inside Bolt2 | 4 | 1" | red | Stainless Steel |  |  |  | Top Bolt / Outside Bolt | 69 | 1-3/4" | black | Stainless Steel |  |  |  |  |  | FINAL LIST pulls all rows with Qty>0
 |  | Inside Bolt3 | 31 | 1" | green | Stainless Steel |  |  |  | [NAME] | 61 | 1" | black | Alloy Steel
 |  | Inside Bolt4 | 4 | 1" | green | Stainless Steel |  |  |  | Middle Bolt / Undermount Bolt1 | 20 | 1-1/2" | red | Stainless Steel |  |  |  |  |  | [NAME]:L$40,SMALL(IF($L$27:$L$40>$V$2,ROW($L$27:$L$40)-ROW($L$27)+1),ROWS($K$6:$K6))),"")
 |  |  |  |  |  |  |  |  |  | Right Bolt | 12 | 2" | red | Zinc Plated |  |  |  |  |  | Item | Qty | Size | Color | Material Type
 |  |  |  |  |  |  |  |  |  | Left Bolt | 0 | 1" | green | Alloy Steel |  |  |  |  |  | Top Bolt / Outside Bolt
 |  |  |  |  |  |  |  |  |  | Outside Bolt | 0 | 1-3/4" | black | Stainless Steel |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Inside Bolt1 / Inside Bolt3 /  Inside Bolt4 | 36 | 1" | green | Stainless Steel |  |  |  |  |  | Middle Bolt / Undermount Bolt1
 |  |  |  |  |  |  |  |  |  | Inside Bolt2 | 4 | 1" | red | Stainless Steel |  |  |  |  |  | Right Bolt
 |  |  |  |  |  |  |  |  |  | Inside Bolt3 | 0 | 1" | green | Stainless Steel |  |  |  |  |  | Inside Bolt1 / Inside Bolt3 /  Inside Bolt4
 |  |  |  |  |  |  |  |  |  | Inside Bolt4 | 0 | 1" | green | Stainless Steel |  |  |  |  |  | Inside Bolt2
 |  | Undermount Bolt1 | 16 | 1-1/2" | red | Stainless Steel |  |  |  | Undermount Bolt1 | 0 | 1-1/2" | red | Stainless Steel |  |  |  |  |  | Undermount Bolt2 / Undermount Bolt3 /  Undermount Bolt4
 |  | Undermount Bolt2 | 8 | 1" | silver | Stainless Steel |  |  |  | Undermount Bolt2 / Undermount Bolt3 /  Undermount Bolt4 | 28 | 1" | silver | Stainless Steel
 |  | Undermount Bolt3 | 4 | 1" | silver | Stainless Steel |  |  |  | Undermount Bolt3 | 0 | 1" | silver | Stainless Steel
 |  | Undermount Bolt4 | 16 | 1" | silver | Stainless Steel |  |  |  | Undermount Bolt4 | 0 | 1" | silver | Stainless Steel