Presumably Columns A to P? Which column would "Yes" show up in? What are the names of the source and destination sheets?
It would be relatively easy to wrire a macro to transfer the contents of the current (or last) row of the first sheet to the first empty row of a second sheet if "Yes" is present. However, I can't for the moment think of a simple means of automating this.