Selected Answer
First, make a copy of your current file in case this messes things up more - as you have a large form, things can get messy.
That said, it looks like you have a great organizational structure for the Validation and Formatting columns
Conditional Formatting
This you just need to start over; your conditional formatting assumes that everything is in the same column, but, you have 2 input columns in your form and, given the way your data is setup, you cannot just copy the conditional formatting down like it was done in the premium course.
For instance, Name1 and Name2 are in different columns, but the formula that controls the Formatting display is all in one column, S11 & S12.
Go to Home tab > Conditional Formatting > Manage Rules > select the rule and click Delete Rule and hit OK.
Now, you will have to reapply the conditional formatting and, in your case, the easiest way to do this is by hand; this way, you will be sure that it is apply where it should apply.
Macro
You made a little mistake here with how to reference cells and ranges and this little mistake was the only error that I noticed.
Let's take formId as an example.
You set it like this:
Set formId = sourceSheet.Range("formIDNumber")
and then you referenced it like this:
sourceSheet.Range("formId").Value = dataSheet.Cells(recordRow, 2).Value
When you Set the variable, you already set it equal to the desired Range on the desired worksheet (sourceSheet), so, you should reference it like this:
formId.Value = dataSheet.Cells(recordRow, 2).Value
In the middle of the macro, where you Cleared the data, you can see that you did it correctly when you used it like this:
formId.Value = ""
Basically, you used the Range object variable that you created as if it were a named range within the worksheet.
Let me know if this doesn't make sense and I can try to explain it better.