Concatenate Excel files

We need a VBA expert to create a code to concatenate ~500 xls tables following the logic below: 1. For each new file, identifies whether the columns already exist in the main table. a. If yes, do not create a new column b. If not, create the new column at the end 2. Add all the registers of the new file into the end of the list in the main file. a. If there is already a register with a similar value for a specific column, add another column next to it with the same name+1 and the second value. 3. Some files have the column "name and surname" instead of "name" only, and might not be the very first column. Therefore, the program needs to identify the first column that has the word "name" on the title and move to the front as primary key. 4. Run a cleansing function to remove all spaces at the beginning or at the end of each cell. * Every piece of data in the files need to appear in the Main file after the process. Example: File 1 Name Phone Post Code John 1234 111222 Paul 4321 113355 Mark 5555 445566 Main File Name Phone Address Marie 9999 Oxford street Ted 2222 Broadway Mark 7777 High str. Result Name Phone Phone1 Post Code Address John 1234 111222 Paul 4321 113355 Mark 5555 7777 445566 High str. Marie 9999 Oxford street Ted 2222 Broadway