Need help consolidating my BOM

First off the spreadsheet contains 4 columns with headers Named:

Cell / Heading / Variables

D1 = "Material" (CRS, SS, ALUM, GALV)
E1 = "Thickness" (#)
G1 thru I1 = "Sheet Size" (Sheet size = width x length)
J1 = "# of sheet required" (#)

I want to be able to consolidate all of my various materials types into one
group then that group will be consolidated into various thickness
then those groups are consolidated into various sheet sizes groups.

Thanks

JES




----------------------------------------------------------------------------
----