Formula/Solution to pull specific information from one workbook to another?

Hi, I'm looking for some help. I have, with some great help already, created the main part of my spreadsheet/workbook. What I would like to do now is create local copies of my spreadsheet that will be saved down in other folders for use by individual departments to view. Master spreadsheet is attached below. The copies need to only display information relating to one department (column L, currently a dropdown menu) and pull all the information from that row into the copy spreadsheet. So in effect I could have as many copies as departments if needed. I know how to link and pull information on mass but what i'm not sure how to do is restrict the copy spreadsheet to only show one departments information. Any help would be much appreciated, I have also noticed the spreadsheet being a bit slow to respond...is there anything i can do to make it run a bit more smoothly?

Thanks!

Hey man, hate to throw this right back at you but its unclear what you want. Could you be crystal clear about what you want? Perhaps an example master workbook and a corresponding client workbook or two with a few data items. It sounds a little like you are not sure what you want, I could be wrong. Happy to help - just need clarification.