Consolidate or What

[agoodson1956]

I have a TAB called KITTING. This TAB has the totals from 7 other tabs. The TABS are labeled STN, MDF, BACKBONE, CCTV, FIRE, ACCESS-IDS, PATH. Each of these TABs have the top row with PART NUMBER (B3), DESCRIPTION (C3), MANUFACTURER (D3), QUANTITY (E3), UNITS (F3).

I would like to also add a section directly below that would consolidate this information if there is no QUANTITY as it is a 1 for 1 right now and many lines have no information.