Do some Excel Work - 18/05/2017 15:14 EDT

I'm making a master e-mail list of my customers. I need to take the following files (which are multi-tab) and consolidate them all into one sheet. I need that sheet to be sortable by each category at the top and searchable. The 4 categories I need on the top are: Company Name: Customer First Name: Customer Last Name: Email Address. I would like it to be alphabetical based on the Company name. If possible, I also need any duplicates removed.