Hi,

I have the 1000 different excel file, each file have multile no of sheet in it. but all the 1000 different file have the same format, only the no of rows in each files will change but the no of columes remain same.

I need to merge all the 1000 files into one file, which will have same structure as the earlier one, merged file will also have multile worksheet in it, same as the earlier structure of the file.