Combine 50 excel file into one new file

[tajulit]

Hi All,

I have 50 Excel file in One folder. Every file has same column such A-E but rows are different. Some have 1000 rows data & another may more or less rows.
I want combine all files data into one file in same folder.


Thanks in advance