Complex function

[Vasilis]

Good afternoon Dear All,

Firtsly i would like to apologize if my question contains any misunderstandings.
I have a workbook where there are many sheets with many informations but i want to take a specific value from all those sheets.
Imagine that there are lists of products per category in each sheet and i want to take the values from the cells with the purchased qty to a another sheet(in order to gather all those quantities to this sheet).,if each qty is bigger than 0.
I tried to achieved that through Vlookup but it seems that it will be very complex(in matter of fact, i confused a lot)
Do anyone have any idea ? by using Vlookup or through developer?

Thank you all very much in advance

 

[Special-K99]

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html