i have 60 workbook in a folder, then i want to select 2 workbook for merging one after another ie:- 2 sheets one after another not in one worksheet, hence finally 30 workbook with 2 sheets each


eg:- i have test.xlsx & test1.xlsx final result in newexcel.xlsx ie:- newexcel.xlsx in sheet1 & test1.xlsx in sheet2

can it be done