Hello, I have a workbook that has 6 sheets. The sheets are shipping locations for one customer and have all the parts that location has bought as well as the pertinent information for the part, ie.. quantity, cost, how many sold in each of the last 12 months and so on. I need to combine all the sheets into one and I need to merge all the duplicate parts and add the totals in each column with each other. For example part ABC, 100 pcs on each tab, i only want to show the part# once and add the 100pcs from each sheet into 1 total of 600. I have attached a picture of the first 6 rows as well as the headers. All sheets have the same headers. I hope I explained this clearly. Thank you