Merge multiple excel file sheets into single excel file with multiple sheets

[sharazkm32 (Sharaz K M)]

Below code will work as expected. Give a try

Keep all the files from which you need to copy sheets in a single folder

Then follow below code. In the properties of copy sheet- provide the destination file path and keep sheet name same as the source sheet name as those are unique

@hacky