I'm not sure if this is possible...

Am creating a multi-page worksheet.
Page 1 contains data from registrants to a multi-distance race. 30 mile, 50
mile, 100 mile.
On that page will be a column indicating which distance.

Page 2 will be the 30 mile
page 3 will be the 50 mile
page 4 will be the 100 mile

How can I have the data automatically forward to the corresponding page?
There must be a function/formula that says if this number is 30, put this row
of data on the 30page... if this number is 50, put this row of data on the
50page....

I don't want to do the filter function because there can be late
registrants and it would (I believe...) mean filtering and copying again to
the corresponding distance page.

Questions? Am I on the right track?
LInda