I would like to have a worksheet that has all of the data (the main
worksheet). I would also like to have 5 'sub' worksheets. Each sub
worksheet would show data from the main worksheet that pertains to that
department - the department is listed in column 'N' of the main worksheet.

I appreciate input to the easiest way to accomplish this. I am working with
MS Office 2007. Thanks for your help