VBA help to copy from one worksheet to another

[Charli]

I have data on a worksheet which will act as the Master sheet. I need then to copy the data to 10 other worksheets according to their class. Once they are in their respective worksheets, I need to delete rows which have been assigned as "sleepers".

I have tried to record a macro, which works fine, but then when I assign it to a button, it wont work!!

I am very new to vba, but was wondering if anyone could help me?!!