Raw data column text to new worksheet - display data based on "Yes" filter

I have an excel ws that has 4 columns that contain yes/no criterion.

10-11-2013 10-10-54 AM.png

If the "Automation" column data has a yes, then I need to display the owner and app name in another spreadsheet with the "Automation" as a value in A:A.

10-11-2013 10-14-14 AM.png

See attached for example

Try the attached

If you want to copy the automation in to column A

Thanks, is there any way to display the text in the filtered column (ie..Automated) in the A column?

This is very close, I just need the text in the column header of the filtered column, not the "Yes" value.

Thanks so much for your help!

Which one is "I just need the text in the column header"? Is it the Automation?

If it the header ONLY.

Correct. I need the text value that is input in "C1" displayed in the A column for each "yes" row

10-11-2013 10-46-26 AM.png

That is perfect! Thanks for your assistance!

Copies the heading for each "Yes"