Combining multiple different -identical in format excels into one

[DGAL1]

 I have multiple Excel files to analyze in qlik sense, however, I want to have a full dataset. My csvs are sales records for the different months, with the same format. How can i work on these since i dont have a field to relate these on.

[qv_testing]

Use this if you have the same structure of files in a folder. (give * instead of filename so it will load all files in the folder)

LOAD FieldName1,
          FieldName2,
          ....so on
FROM
[C:\FolderPath\*.xlsx]
(ooxml, embedded labels, table is Sheet1);

[Chanty4u]

Use this sample

SalesData:

LOAD *

FROM [Folder Path\*.xlsx]

(ooxml, embedded labels, table is Sheet1);

Concatenate(SalesData)

LOAD *

FROM [Folder Path\*.xlsx]

(ooxml, embedded labels, table is Sheet1);

[Anil_Babu_Samineni]

@DGAL1 Your subject says "multiple different -identical in format excels" ,So we appreciate if you can explain how the layout in columns from excel file?