How to create separate sheets according to value of particular column?

Guys Is there any way to create separate sheets in excel according to value of particular column

Say I am creating records of my class mates in which there is column which requires choosing among two choices ie yes or no

Now what i want to do is to create a two separate sheets according to value of this column, one will contain all the students who choose Yes and other will contain all the students who choose No

Is there any way to do it automatically?