Analyze and cleanse some Data on various CSV FILES - data clean up.

I have one Excel Sheet with 16,000 Email addresses on it. Dont worry most are dupes. I would first like to take the types of emails listed and segment them into different sheets representing the groups. The master sheet has a number of groups of emails listed: For example Radio Emails TV Emails Corporate TV Emails Linked In Emails These groups should now be placed onto separate sheets separating the categories or types of email addresses. Also you will see there are a number of CSV files – these have been downloaded from Mail Chimp. They represent some of the following Bounces Unsubscribes Opened Sent to The bounces, unsubscribes and opened need to be removed from the lists and the sent to emails need to be placed in their own sheet with the date they were sent to. As you can tell I am looking for a way to collect data that has not been sent to yet and remove data that is useless, has been sent to or has bounced or unsubscribed. Ask questions and please do not ask for money until the file has been agreed. Do not bid on this project unless you are completely expert in Data / Emails and Excel sheets. End result: One master data sheet of clean. Radio Email Addresses TV Related Email Addresses Corporate TV Related Email Addresses. Where possible – please discuss, I would like it so that no email appears on the same workbook twice. This is to ensure that I do not email future clients twice. We will then De Dup all the email addresses across the whole Excel File. So that only active email addresses remain. Any name information next to the email address should be retained where possible. I also need to find a way to then cleanse the list to remove role based emails and those that are bad emails.