Copy Rows based on 1 criteria showing in Multiple columns

[smartbuyer]

Hi Guys,

I have attached a file with questions in it.

Found a lot of codes that lets you copy to new sheet based on criteria but having trouble finding one that sorts through 3 columns then copying specific columns based on the 1 criteria

Appreciate the help and inputs

[patel]

it's not clear for me, need source data and desired result