Display multiple search results in a row

Hi everyone! I'm trying to make this work without using VB or pivot tables..

I have the next data:

aaaa 123
bbbb 343
cccc 333
aaaa 1323
vvvv 444
... etc

I want to make a function to search all the results for "aaaa" and show them in a row of another sheet:

123 1323 .. .etc

Does it make any sense?

Thank you in advance

Something like this:

Not quite..

I want to show the results on rows..

anyone? I'm still stuck with this

last up :D