Creating a summary sheet based on other sheets

[meetarun007]

I have excel file in which each sheet will be filled by a different clients (Client1, Client 2, Client 3.. Client n). Each sheet will have two columns "Description" and "Quantity". Client will add the descriptions and quantity.Apart from the sheets filled by clients, the file will also have a sheet called "Summary".After all clients filled, I need all distinct "Desciption" and "Sum Quantity of that Description" in the "Summary" sheet.Referance Image: http://s2.postimage.org/n5mcs7km1/Excel.png

 

[Robert Mika]

I have excel file in which each sheet will be filled by a different clients (Client1, Client 2, Client 3.. Client n). Each sheet will have two columns "Description" and "Quantity". Client will add the descriptions and quantity.Apart from the sheets filled by clients, the file will also have a sheet called "Summary".After all clients filled, I need all distinct "Desciption" and "Sum Quantity of that Description" in the "Summary" sheet.Referance Image: http://s2.postimage.org/n5mcs7km1/Excel.png

look here:
http://www.mrexcel.com/forum/excel-...ts-how-ignore-blank-cells-worksheet-list.html

or here:

http://www.mrexcel.com/forum/excel-...orksheets-vlookup-array-sumproduct-sumif.html