I newish to this,

I have a list of 1000 stores names in one sheet of which approx 100 have an flag 'y' against them in column b.

I need a routine to go through the list of 1000 store names and populate another sheet with the store names where the flag is 'y',

I need to run the regularity as the list of 'flagged' stores frequently changes

Any help gratefully appreciated