I need to be able to lookup information on a specific sheet and have every instance of a specific word be placed in a column on another sheet.

So, if I have a ton of data on Sheet 1, I want to be able to have a heading on Sheet 2 that says "Ace", and have a function that looks for the word "Ace" on Sheet 1, and places every instance of this word under the heading "Ace" on Sheet 2.

So on Sheet 1:
Ace 34
Blue 32
Ace 99
Green 34

On Sheet 2, you would see:

ACE
Ace 34
Ace 99


any help?