Drop-down results in multi-row output

So I don't know if this is possible, but here is what I want to do: I have a list of about 100 golf drivers with 4 characteristics each. I have created a 5 digit name for each driver, and listed the 4 characteristics in the cells below. For example:

T2543
Titleist
460cc
45 Inches
New

S4522
Taylor Made
410cc
44 Inches
Used

etc...

The pricing excel tab I use has 5 rows that correspond to each of the characteristics above. Instead of manually typing in "T2543, Titleist, 460cc, 45 Inches, etc" for each driver, I would like to use a drop-down that automatically pulls the info for each driver code. That is, the drop-down would list T2543, S4522, etc. Once selected, it would populate the 4 characteristics into the cells below.

I am thinking it would take another tab from which a formula draws. Everything I have found thus far regarding drop downs, however, only results in output that is one cell.

Hopefully this makes sense. I am a new at this. If you can point me in the right direction, I would appreciate it.

Thanks.

Yes!!

Much thanks.

Alright - Sheet 3 is really what I needed.

However, I need the "Select from list box" section to be on a different worksheet than the data (e.g. 1a, 2a, b1, b2, etc).

Do you know how to accomplish this?

When I am doing the INDEX formula and the data validation, I don't know how to reference a separate worksheet.

Thank you.