Hey everyone!

So, I have three sheets of data that I want to pull certain values from to a master sheet.

I was wondering if it was possible to have a dynamically updating list of either distinct or unique values, and which of the two would be better.

For example,

between all three sheets could contain a row of data that include (Apple,42), (Banana,42), and (Apple,19). (Also, product name and age number would be in different cells but in same row)

Because (Apple,42) and (Banana,42) have different products, they would be included in the master sheet; and because (Apple,42) and (Apple,19) have different ages, so would (Apple,19).

This is shown in summary1.

On the other hand, maybe it would be better to pull all unique age values between the three based on the criteria of product name?

This is shown in summary2.

Here is an example of how it would look:

Example.xlsx

Ignore the Qty and Total Qty; I already have formulas for those.

Thanks for any help and tips!