Auto-populate from other sheets in a master, than auto total duplicates

http://www.excelforum.com/excel-prog...-workbook.html

I found the above thread and this worked with what I needed to do, but I was wondering. I am using part numbers and QTY on 7 tabs ( different sections of macahines). The same part number could be used in the different sections (o-ring as an example) is there a way that when it auto populates on the master sheet that it can tally and provide a grand total if there are duplicates entered?

I have highlighted the duplicates, on the master but not sure how to go about consolidating the totals

Any help or advise would be great

Thank you