Macro to automatically copy and paste rows to different Sheet

Hi,

I'm new to VBA, but I would really appreciate if you can help with creating a macro to copy rows to different sheet.

There are two version of the same excel file. One of the file(test22) is compatible with excel 97-2003.

test.xlsx

test22.xls

The workbook has two sheets one is 'Names' and the other is 'ColumnF.'

All information will be updated to the "Names" worksheet, which is the main sheet and I would like to automatically move any rows with 'Yes' for ColumnF to the "ColumnF" worksheet. But the rows should only be copied up to ColumnE.

I would also like to have a Yes or No selection under Column F, if possible. Thank you.