Can any one help me?

I want to consolidate 26 workbooks into one new summary sheet.

If the same product code and colour exits in the 2 workbook add the values
together, but if the product code has a differnt colour insert into a new
row.