I have
I have workbook with 300 worksheet
like that 5 workbooks
i have to combine 300 * 5 in one workbook
workbook names
Segment 001 of DILWARPUR.xls
Segment 002 of DILWARPUR.xls
Segment 003 of DILWARPUR.xls
Segment 004 of DILWARPUR.xls
Segment 005 of DILWARPUT.xls
worksheet names
Page 1, Page 2 upto Page 300 in every workbook
i have to combine 300 * 5 in one workbook
|