excel macros

I had help with the macros for this spreadsheet and I'm not sure if that's what not working but none of the drop down list are populated. Can someone help me?
james_chapman