Creating a drop down list that is based on the contents of another cell

Hello Everyone,

I was hoping an excel guru could help me with this questions.

I need to create a drop down list (easy to do), however that is based on the contents of another cell. For example:

Lets say I input "Name" into A1, then cell B2 would have a drop down list that give the following choices "First", "Middle", or Last. Now lets say I input "Address" into A1, NOW excel will have a drop down choice in cell B2 say, "Street", "State" or "Country". Now lets say I input "Activity" into A1, NOW excel will have a drop down choice in cell B2 indicate "Running", "Jogging", "Talking"

Does anyone know how I can perform this function?

Thank you so much,

that made things a whole lot easier.