Hi All,

I need some help with merging multiple excel files into.

I have timesheets saved on on a central location in one directory. Around 50 excel sheets. All these have same format.

Can somebody help me with some code to loop through all the given workbooks and merge the data in one master workbook one below other.

In all these workbooks, There is just one sheet. No more.

Thanks in advance....