I would like to create a workbook that allows me to type data into a master sheet (3 columns Name, State, Department) I would then like the information to populate onto other worksheets according to the data. Example:

Column1 Column2 Column3
Name State Dept
Dan CA ops
Erin TX admin
Karen CA Admin

I would like worksheet entitled "California" to pull all of the rows onto it from the people that are marked "CA" in the state column so that it would look like this:

Name State Dept
Dan CA ops
Karen CA Admin

and so on for each State worksheet

Is this possible? The only way I could think to do it would leave gaps in the lists (say if I was using an "IF" command it would pull row 5 to row 5 and leave blank rows for false statements)