Need Macro to clean up poorly formatted data

I need some help writing a macro that cleans some ugly data up and makes it presentable. I've attached the sample spreadsheet that I just cannot get to look pretty. We get daily reports like this in excel format and I'm trying to create a macro where I can just copy and paste the daily data onto a sheet, run the macro and it will format the data nicely and allow for a pivot table to be run on it. New people are added every day so the macro would have to account for that. Can anyone take a look at the sample I have provided and point me in the right direction? I am willing to pay for services if needed. Thank you in advance!