Populate cells in sheet2 using dropdownlist with data frm sheet1

Hi, I hope I worded my question right. What I have currently is;

Sheet1 is populated with a lot of horse racing data from the past 2 years, and I am trying to pull specific data by horse name into a group of cells, or a table (whatever works) on sheet2.

What I have done so far is selected and named the AA column of horse names in sheet1 and created a dropdownlist on sheet2, using data validation pointed it at the named list of horse names on sheet1 to populate it.

Now what I would like to do is use the dropdownlist to fill a row of cells in sheet2 with data from sheet1 based on a selected horse name from the dropdownlist.

Also if possible, there may be more than one row in sheet1 with the same horse name, because each row is a record of a race ran, ideally I'd like to pull all rows (of selected cells) where horseName = horseName from sheet1 into sheet2, using the dropdownlist.

I'm not sure if this can be done in excel 2007 without writing some VB, I'm no expert, more of a tinkerer lol.
Any help would be very much appreciated :)

TIA