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