Excel Macro Required

First, I have attached the spreadsheet that I am talking about. What I need to do is copy all rows from one sheet to other sheets based on the content of cells in one row. I have built the spreadsheet and right now my command button works on 10 out of 16 sheets. It's the same code but for some reason it does not work on some sheets. What I want to do is create one button that copies the rows from a sheet that has all results to the individual sheets that correspond to the data. Also, I need a button to delete all rows in a range from all sheets except for the master sheet that contains all data so that the sheets reset for the purpose of copying across new data. If I don't delete all rows then a macro copying rows will copy the same rows again plus new rows. So let me now refer directly to the spreadsheet. The first sheet, Overall Results, contains all data. At the top are all stats. Below is all data. Now look at sheet "Craig1". As you an see there is a command button and when clicked it copies all rows from "Overall Results" starting at row 16 column B where the cell in column B = "Craig1" This works fine. Sheet Craig2 has the same thing. Same code just modified to refer to Craig2. For some reason though it won't work for sheet "Craig7" for example. What I really want to do though is create just one command button that deletes all data in a range of cells of all sheets EXCEPT for sheet "Overall Sessions". Then I want one command button that brings copies all rows from Overall Sessions to all sheets whose name corresponds with the text in row B of overall sheets. I know this is difficult to explain but if you look at the spreadsheet and the VBA of the command buttons you will understand. I don't want a command button on each sheet named "CraigX". I want to change it to just one command button that will copy all data from Overall Results to all sheets that correspond with the data. And as for deleting data from all sheets called "CraigX" - I want one command button to do that too. In reality this is maybe a 30 minute job for an excel expert. Please quote or message questions.