i'd focus some attention on the dynamic table name issue. For example, you have <cfparam name="form.club" default="Not Entered">
My guess is based on form values dictates which table to insert into? With that, there needs to be a more failsafe method of determining which table needs to be in the INSERT statement based on passed form values.
Maybe something like the following:
<cfif IsDefined("form.club") AND form.club neq "" AND Len(form.club)>
<!---- run your code here for the rest of the form values and insert.---->
<!---- Maybe add a conditional that aids in the selection of the table for the insert statement to work with based on passed form values.----->
<--- error message about the insert failing ---->
let me know if I can be of any additional assistance.