Create named source range

Dear all,

I'm a new member and I would like to create e macro with merge several data from different workbooks contained in a specific path.
I created the macro but I noted that different workbooks are not the same. Thus, the columns named "total amount" and "currency" are not present in the same position. Therefore my source range cannot be AD:AI but is should find my colums in different workbooks and then copy the entire columns in another new workbook which summarize all files contained in the path defined.
Could you please help me?

Currently I setted the following information:

Please Login or Register  to view this content.

As you can note my files are xlm and not xls.

I thank you very much in advance.

Use Range.Find to return the position of the two headers, then modify:
SourceRng:="AI:AO", accordingly.