I have 5 excel workbooks with 3 sheets (Total 15 sheets) with similar structure. I need a macro which can merge all into 1 workbook with 3 sheets. To describe my output workbook should have : 1 st sheet will contain all data of first sheets of all workbooks row wise and 2nd sheet will contain all data of second sheets of all workbooks row wise and so on. As its urgent can anyone help pls
Bookmarks