Macro to copy row data into new worksheets and separate delimited data

I just realized looking at the sample I provided, that is didn't save the latest changes I made. The template is wrong as well. Here is the correct sample data file. Sorry about the confusion.