Updates to be made to our XLS data

We have around 80 excel files all of which have around 300 rows of data. We have a series of things we need doing to the data such as

certain columns deleted
columns arranged in order and renamed
, removed from columns
- removed from columns
some rows have multiple emails in email field and we need to only have one and make sure it is same as town or if not then info@
some rows have multiple telephone numbers in telephone column and we need to only have 1

There are a few other things we need doing to certain columns but they are just find and replace commands

I am aware you can create marcos to complete this but i do not have time to find out how to do it