I would like to pull the data from columns C and J only from rows where
column F reads "Closed" and with this data form a list in another worksheet
in the same workbook. Just to clarify, I don't want the data to disappear
from worksheet 1, just it should automatically populate in worksheet 2 when
cell F reads "Closed".
Is this possible?

Thank you very much,
Scott