Extracting certain data depending on criteria

Hope there is an easy solution to this.... lol

Have a perfect working spreadsheet, but now need to extract certain bits of data depending on one criteria.

Each row contains data in different columns.

What i need to do is depending on the criteria of a cell (i.e. whether its Y or N) i would like to extract certain cells onto another worksheet all within the smae work book

i.e for example
If i have columns A,B,C,D,E and F and then x amount of rows (as these can change as data is entered) if a Y is entered in F then it extracts the data out of columns A, C and D