Hi guys,

Need your help

I have 700 excel sheets in xls and xlsx format I need to merge all sheet in one excel or access.
all the sheets have same Column name. But the issue is Sheet data starts from cell D1 OR E1 rest row contains description of sheet that not required in the new centralized sheet.

So, please with this guys


Thanks in advance