Struggling to move & link data without access

Hi Im trying to do something that I could do easily in access but we can no longer use it where I am. So I can only use Excel & my brain doesnt seem to like it. Its to extract data from a survey

The full survey data would be in one sheet for example

name|age|hair|weight| ever seen UFO| where | how big
Dave| 23 |none|23.67| Y



The data will be updated each week in a master data sheet on a spreadsheet to a maximum of 30,000 rows but only an estimated 70 will choose Y for ever seen a UFO.
So I would want to have a formula that (in another sheet) copy's the full row of data if any cell in that column is Y.

I'm struggling with that but if I could throw in something else I have added 2 blank row at the end. The perfect result for the survey would be if the the new sheet with only the Y rows showing would allow these blank cells to be updated & that new data to link back to these same cells in the master data so the master sheet can be analysed properly

Like I say it would be pretty simple in access but I'll open it up to you excel experts to show me Excel is equally up to the job
Thanks