I am trying to make a spread sheet so if for example on sheet 1 I have

A B C D
1 Big $5 3
2 Medium $3 5 yes
3 Small $1 4

I have a "yes" for the Medium row, How do I make it so that only the medim
row shows up on sheet 2 but if the other 2 would have "yes" in the D column
they would too?