Cancel merged columns and arrange structure across files in the folders

[Abdo]

Hi,
I would cancel merged columns and cells across all of files are existed in this device"C:\Users\Abdo\Desktop\TYR"
each file contains different counts sheets also I would arrange columns across files from A,C,E,H,M,N,K to A,B,C,D,E,F,G across sheets for each file.
so the macro should be in MASTER file is open , others files are closed .
the result should be for each file is closed , but the macro should in MASTER file
all of files are xls extension .
thanks.
.

 

[Joe4]

In order for me to help you, I need you to answer the questions I ask you and not ignore them.
What I am looking for is a simple column mapping, something like this (the following is just an example of what this would look like):

where "Original Column" lists all the columns on the original sheet, and "New Column" lists where these columns should be mapped to/end up when the macro is complete (and deleted indicates that original column is to be deleted and not shown in the final result).

It is a very simple ask, but gives me a clear picture of exactly what you are trying to do.
Are you able to provide this?