Is it possible to have a macro search for a word down column A and when it finds that word begin copying data in the row it found the word but in a differnt column, for example column E?

For example:

A B C D E F
1 NO
2 NO
3 YES 2 4 6 3 7
4 NO
5 NO

So when it finds the word Yes it would copy cells E3 and F3 into a new sheet.

Please Help I've been trying to figure this out for weeks. Thanks!!!