Transfer from one sheet to another.

Hello,
I have an Excel workbook that I need help with.
On sheet one I have a column with client's names (B6-B35, B37-B66).
On this same sheet I have a column for training (M6-M35, M37-M66).
There will be "Y" for yes, and "N" for no entered in this column.
When there is a Y entered in the training column I need for the client's name to be automatically entered into a column on another sheet.
This will be the training sheet and I need the client's name entered in C6-C29.
It does not need to do anything if N is entered in the training column.
I also need for the names to remain in the training column if the Y is changed to a N in the training column.
Thanks