This is probably a lot easier than I'm making it, but I'm lost!

I've created a multi-sheet workbook in Excel 2007 to keep track of our DVDs,
audio CDs, video games, etc. Each sheet is devoted to a specific media type.
I'm about to start entering our audio CDs, and here's what I would like to
accomplish:

First field: Artist Name
Second field: Name of album/CD
Third field: A dropdown list of the tracks on that CD.

Everything I've seen/read about creating combo boxes/dropdown boxes indicate
I have to enter the information that I want to appear in the dropdown
somewhere else in my spreadsheet. I don't want this dropdown to be
'selectable' as one would normally expect from a dropdown, I just want a
dropdown of static information so if, let's say, I'm looking for a specific
song by a specific artist, I can find it easily. Which brings up another
question - is the information in this dropdown box searchable? Is what I want
to do possible?

Any help/guidance would be greatly appreciated. I used to work for Microsoft
but I never dealt with Excel much and I'm really clueless on the development
side - I did end-user support in operating systems and networks! Thanks in
advance for any help anyone can provide. Feel free to email me:
- thanks again!