Macro to search for text then copy data from that row starting in different column

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!!!

See attached

Thanks so much!!! This is what I need! I think I did a bad job of explaining however, I need the macro to continue copying until the end of the row not stoping at column F. Can you help with that?