I have a register of entrants.
Columns FOR ALL SHEETS Are:
Rider Name | Race Number | Class

The class is selected from a list.

Is there a way I can have the data transfered into a seperate sheet (NAME,NUMBER,CLASS) after a have selected the entrants appropriate class.

i.e. Classes are X, Y, Z.
Sheet 1 has all entrants in a list.
Sheet 2 I would like anyone I input as Class X to appear here.
Sheet 3 I would like anyone I input as Class Y to appear here.
Sheet 4 I would like anyone I input as Class Z to appear here.

basically as I input data into sheet 1, I want it to be automatically populated into seperate sheets depending one what class is selected.

Is this possible?

Thanks for any help.