VBA to split commissions from one sheet to multiple sheets and summarize by account type

I'm doing my best to understand the code but it's been awhile since I had Visual Basic .NET in college

I have it set up so that I can paste my report data into the Data tab and Sheet1 pulls that data and formats it properly. I found a workaround to the tab length restriction of 31 characters. It's not in this file because I changed the salesperson names but for salespeople that have more than 31 characters, it does a vlookup on Sheet2 and replaces it with an abbreviated name. I also added a disclaimer macro to run at the end of the CreateReports macro to insert a short disclaimer at the end of the data on each tab.

I changed the paste command to be PasteValuesAndNumberFormatting which seems to have partially fixed some of the data that was populating the new tabs. The dates are now correctly showing on the salesperson tabs, however, I'm still having trouble with the layout of some of the reports. I'm hoping that by changing the paste command I haven't messed up anything else.

Would you be able to help me figure out why the formatting doesn't work as it did in the original sample file? I tried to have that sample file be similar to the way the actual report looks. I opened the sample file again and made a second ABC Corporation electric account and the formatting came out the same as the report attached to this post.

Anything you can do to help would be greatly appreciated.