I have several Excel worksheets that consist of three columns description, part number, and quantity. I want to combine them all into one worksheet so that quantity's get added together for rows with the same part numbers (bad description probably).

Can anyone tell me how to do it ? Compare and merge workbooks will not work because they are not the same worksheet (unless I am doing it wrong)