A macro that automates cleaning and merging of weekly client data. It cleans data output from a raw source and then merges data from another source once it's available later in the week.