Supoose I creat a list of staff with therir designation.

Now I want to filter only 1 type of designation from the list, which will be
displayed on other sheet, means If I update list, it will automaticaaly
update on the next sheet with that particular data

How could I do it