Creating dropdown menus

Hello,

I work for a HR director who asked me if I could develop a better system to organize potential employees through Excel, some sort of database if you will. Honestly this is beyond my skills so I've come here to see if I can get some help. What we have now is the first column lists candidate's names while the first row list several jobs/skills and throughout the whole spreadsheet there is either a yes or no for the candidates (View attachment "Example"). What I need it to do is have the all the jobs listed in one drop down box and put them where each individual job is now so the HR director can select one job and it brings up all those candidates and then select another job and it will further filter through the candidates. There is probably a way to do this through multiple spreadsheets, one which holds information and the other that displays it but like I said earlier, it really is beyond my skills to do that. So any help would be greatly appreciated

(Using Excel 2007)


James