I need an excel expert

I have hundreds of csv files, they are in many different formats however all files have a column named "email" or "email address" I need to pull a list of emails from all the files into one single file. If possible I would like to pull the column named "Company" or "company name" and "first name" and "Last name" but the most important thing is that I can pull all data from columns named "email" /"email address". I VBA to do this would be my preference


I need this urgently for a very quick turnaround