Need to merge two excel but with different sheet number

I need to implement following

Excel 1 with Data in Sheet 0

Excel 2 with Data in Sheet 1

Need to have Output Excel with two Sheet having data from above excels.

Output Excel- Sheet 0 will have data from Excel1 and Sheet2 will have data from Excel2

Can anyone suggest

Participating Frequently

New Participant

Merge excel is working but its not combining column wise its combining rows wise even below mentioned plugin is not working for me.

Sign up