Copy data to another sheet in sequential fashion

I am hoping somebody can help me with this as I have not been able to find an answer.

On one sheet a user answers Y or N to as series of questions. I envision another sheet that would only list those rows that were answered N. I would like the summary of N's on the new sheet to be listed from row 1, 2, 3 etc...

Any ideas?

Thanks, Jim