Help with Xl and dropdown lists

[support]

I am trying to create a "Dynamic" spreadsheet based on values contained
from 3 other worksheets

Sheet 1 contains a list of artists:
artistID, artistName

Sheet 2 Contains a list of genres
genreID, genreName

Sheet 3 Contains a list of labels
labelID, labelName

Sheet 4 contains a list of Albums
albumID, albumName, price

Sheet 5 contains a list of music tracks
catNo, UPC, albumID, title, artistID, trackprice, genreID, labelID

I am trying to create a series of dropdown lists in Sheet 5 for
albumID, artistID, genreID and labelID.

However.....

I can create the lists to show the names of the relevant albums,
artists, gernes and labels without a problem. My problem is that I want
to be able to select the Name columnsfrom the 4 other sheets but
contain the IDs instead. I am doing this so that I can export the data
in sheet 5 as a csv for a mysql export routine. The csv would then
contain ids and not names.

Can any one help out or point me in a much needed right direction

Many Thanks

Craig