Copying Certain Category from a Mastersheet to another Sheet


I have a master sheet with certain category of staff. Is it possible to copy a certain category from the master sheet to another sheet? Eg if the mastersheet contains "teachers" and "students" and I only want to copy teachers to a new sheet when added to the mastersheet containing students and teachers.

Any help would be appreciated.

Best Answer