help with creating array formula to index and match

I have a workbook with two worksheets. Worksheet A I have a number of locations listed in column A and in column B,C,D,E... I would like to know all the associates assigned to that location based on job code. There wouldn't be more then 4 associates per job code per location.

In worksheet B, I have a master listing of all the locations and all the associates assigned to those locations and job codes. The master listing isn't in any order.

This is what the raw data on worksheet b looks like. I kept it simple with only one job code, but there would be multiple job codes and around 1000 rows.
7-14-2014 10-11-31 PM.png

This is what I would like the result to look like.
7-14-2014 10-11-59 PM.png

I need this list to update automatically every time the associate master listing is updated. This information is provided to help District Managers know which Store Managers are assigned to each location.

Thanks

Got the solution Man....
check the attachment...
I have used array formula so use ctrl + shift + enter to enter the formula...
don't use only enter..


Don't forget to click *

Thank You!! That's works! I've been working on this all night!