Automatic Data entry manipulation

I have a master sheet of data that my coworkers are using to input data from outreach efforts. It looks similar to the snippet below. This is only an example so I am not sharing confidential informat...