Kutools For Excel -

Step 1: Combine multiple workbooks into one workbook.

Kutools for Excel is a popular add-in for Microsoft Excel that provides a wide range of tools and features to simplify common tasks and enhance the functionality of the spreadsheet software. With Kutools, you can automate tasks, customize your workflow, and gain more insights from your data. kutools for excel

"Sir, the trial is free, but the license costs a fraction of an hour of my overtime pay. Last night, I saved roughly ten hours of manual labor. If I do this four times a month, that’s forty hours—a whole work week. It paid for itself in the first hour of last night." Step 1: Combine multiple workbooks into one workbook