creating a bill of materials from several tabs

[wattzz2000]

I am trying to total up materials entered across 80 tabs.
I want a macro or function that will look in certain rows and columns to see if there is data there, if there is I want it to copy the information on to a separate sheet. If there are multiple entries with the same name, then the total quantity and price will total up.

D17:D28 is the name of the materials (this will repeat at times across 80 tabs)
F17:F28 is the Unit Totals (this will need to be added cumulatively if the materials names in the D column are the same)
G17:G28 is the unit measure (EA, SF, etc)
H17:H28 is the total Units (this will need to be added cumulatively if the materials names in the D column are the same)
I17:I28 is the unit cost (this does not need to be returned)
J17:J28 is total cost (this will need to be added cumulatively if the materials names in the D column are the same)

 

[Peter_SSs]

Duplicate to http://www.mrexcel.com/forum/excel-questions/948596-consolidating-data-multiple-sheets.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.