Hi @AshwinS2
I have created workflow based on your requirement here I used your attached two excel files.
1.First excel file(test1.xls) sheet name UM1.
2.Second excel file(test2.xls) sheet name UM1
3.Finally I merged above two files and save to Output.xls file
MergeTwoExcelFiles.zip (20.0 KB)
.