How do you create a live, filing list?

Here is another thing I am now trying to do...not even sure if it is possible with excel.

I want to sift through a column for the word yes... and if the word is yes I want the stock symbol that it relates to.... the stock that is in the same row, just the next column over, to pop up in another work ship in slot A1.... I then want that stock symbol to stay there for 15 seconds even if the word yes has disappeared from the first work sheet.

If there is another yes that comes up next in the orgininal worksheet, I want it to pop into column A1 replacing the old stock.... I want the old stock to then move to B1...

Both will disappear after 15 seconds.

So basically every time a yes appears in a column... that stock symbol will appear in another work sheet and create a list that moves if there are any new symbols with in 15 seconds.

Do you know if this is even doable? Is it doable without the 15 seconds? Thanks a ton for your help!