Sheet1 is my main table where all my data is collected from a race entry
form. I need to seperate this info into different sheet which are for
different age groups, The categories are Under 16: A, AL, Under 14 B, BL, and
Under 12 C, CL, .... The letter A, B, C are for boys and the letters AL, BL,
CL are for girls. I do not want to seperate the boys from the girls in each
cat.

How do I create a formula that will take curtain info across to each sheet
and will not be effected if sorted into position order.
My table is set out like this.
No., Name, First Name, Surname, Club, DOB, Boy/Girl, Catergory

I hope this makes sense.