Drop down lists and pulling data from worksheet based on drop down selection

I am in need of some assistance. I am trying to implement a new staff directory for Special Education staff assigned to schools for the very large school district I am employed by. I have created a data worksheet (Master) with all 180 schools and up to 13 staff members in various roles at all schools ranging from cells B2 to O183. I have created a drop down list on the primary worksheet (SESStaff) along with fields that I need to pull staff names from and populate from the (Master) data set and put into those fields for administrators to view based on their drop down selection. I know this is MUCH easier in Access, but the system requires me to do this in Excel. Any help is MUCH appreciated!

The attached screen shots are the two worksheets in the spreadsheet I am creating.

In 'frontend' you will see a drop down list and when a school site is selected I need it to pull data from the other worksheet 'Master' and populate the cells marked with the red arrows under the staff position title for that school.

Hi
it's best to attach a workbook/sheet so that we can work on it. (screen shots do not help much)
Thanks

__________________Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)Want to thank for the help received ? Click the scales symbolin the upper right corner of a post from the person you want to thank.