Thanks for the code. It works perfectly, but I did neglect to include something.

I've updated the sample spreadsheet to show a title on the worksheet. I was wondering if it was possible to have the title copy over on each of the worksheets when the macro splits it all up.