How to combine the 6 excel workbook in to one worksheet.

[ajmal pottekattil yoousuf]

I have 6 Workbook and 1000 rows in the each workbook.

I needed to combine to one workbook.

[#2]

PowerQuery is one way to do it:
https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query...