i am using Kutools plus to combine multiple workbooks with same sheet name into 1 workbook.
I am getting the result i want but i am facing 2 problems:
-it is combining the sheets with header line (so i am deleting manually the un-needed headers)
-i am having blank rows between each sheet (sometimes up to 100 blank row)
how can i fix the above issues?

thank you