Dear Friends,
Please help me to solve this query.

I have a 40 workbooks with single worksheet in it, i just want to merge all those 40 workbook with single sheet in it with master workbook containing all those sheet.


thanx in advance