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