Hi,
I need help with a macro
The scenario is
I have 30 Excel with 5 sheet in each in a stored in a folder
What I need is to get all the sheets (i.e 150 sheets) to be pulled into a new excel file.
Can anyone help me with a macro to get all the multiple workbook with multiple worksheet to be pulled into 1 excel ?
Thanks,
Tejas
Bookmarks