Can anyone help me create a vba function to execute the following?

In *Sheet1* I have 3 columns `A(product)`

and `B(price)`

which are populated with *3000 items* and 3rd column `C(quantity)`

which is not populated
now.

I want to add quantities to certain products which will be done by finding the product and enter the amount in the corresponding cell C.

Then in *Sheet2* or even specified different workbook to have added only all the products and prices and quantity that have quantity introduced.

For example, I have *Sheet1*:

I want to have sheet2 or a specified sheet/workbook automatically populated with the products and their matching prices and quantity that have quantities on like this:

I have managed to create an excel function but the products list is changing weekly and every time I have to copy/paste the formula and adapt the source file and is a complete hassle.

The formula I have made is here:

```
=IFERROR(INDEX('Products'!$A$5:$C$2655,SMALL(IF((0<'Products'!$C$5:$C$2655),MATCH(ROW('Products'!$B$5:$B$2655),ROW('Products'!$B$5:$B$2655))),ROW(A11)),COLUMN(A11))," ")
```