Do some Excel Work

Hi, I need some basic Excel work done as detailed below: Step 1: Combine the attached spreadsheets and all of their tabs into one sheet retaining all the columns, and delete any duplicate emails. Call the new sheet : L&D Managers 2014. Now do all further work on this sheet. Step 2: UNDELIVERABLE (451 EMAILS) I will send all the Undeliverable messages to you. You need to go through the spreadsheet and mark in RED any names that are undeliverable. Then move these to a separate sheet marked, UNDELIVERABLE. Step 3: Out of Office (126 EMAILS) - I will send all the Out of Office email messages to you. You need to go through the names and find these names that in the spreadsheet. If they were simply out of the office and expect to return (for example out for that day, or on holidays etc) mark in YELLOW, if they were no longer returning to the role mark them in RED and move them to the UNDELIVERABLE sheet. If any of the Out of Office replies have replied with a new contact EMAIL of the person taking over their role or someone else to contact in their absence, then add these to the list and mark in GREEN. If they have given new contact NAME only (and no email of the new person) then copy the format of the existing email for example: and insert the new persons details and mark these in GREEN. Step 4: REMOVE FROM LIST (25 EMAILS ) - Mark these names in BLUE and move them to the UNDELIVERABLE tab Step 5: REPLIED (166 EMAILS) - Mark these names in YELLOW and keep on original list. PRICE IS FOR COMPLETION OF JOB NOT PER HOUR