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

Have a look at this addin

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post