Multiple Dependent Lists based on Selection in 1st Column

Hello Everyone,

I have been using the forum a lot the past few days and have been able to find help on all but one (at the momemt) item for my spreadsheet. I'm not sure if this is possible but...

What I am looking to do is this... (using Excel 2007)

I need to have more dependent lists based on the selection in Column A. (My column B is already set up and works perfectly using INDIRECT)

For example:
Column F would be a dependent list of colors based on the sales rep chosen in Column A
Column I would be a dependent list of managers based on the sales rep chosen in Column A
Column M would be a dependent list of part numbers based on the rep chosen in column A

Is it possible to do this - without using VBA? (If I HAD to - okay, the other person maintaining the sheet would be lost....) I haven't been able to find anything close to what I want to do online - maybe I am just not using the correct terms.

Thank you very much!!!
(my apologies if I placed this in the wrong forum...)