Create new worksheets from master sheet based on column contents. Only copy certain fields

I have a master worksheet that I update continually every day. In attached file example, all fields will usually have data. Is it possible to create new worksheets based on the contents of the Dept/Campus field? So all Campus1 will go on one worksheet, all Campus2 will go on another sheet, etc. In addition to creating new sheets based on the Dept/Campus, I would then like to only copy over these fields from the master sheet: Dept/Campus, Last Name, First Name, Job Code Descrip, Antic FDO, Actual FDO, and Antic RTW. Ideally each worksheet will have the tab name of the Dept/Campus.
This can be something that either updates each time I update master sheet, or else something that I would just run once per week.
Once I have separated these into multiple worksheets, I want to create each new worksheet into a PDF. I would be PDF'ing only once per week.
I can provide additional clarification if needed... thanks for any help you may have.

With 1 button to update/Create the sheets and 1 for create PDF

Please Login or Register  to view this content.

Kind regards
Leo

works perfectly, and my life will be so much easier. Thank you!