By using Extra tools add ins of Excel, we can simply select one or multiple Excel files (all Excel file in one folder) to insert their sheets in just one Excel file. If you select one Excel file, then you can choose which sheets to be inserted in your desired Excel file. If you want to merge multiple Excel files, then you need to move those Excel file in one folder. Then by choosing that folder from desired Excel by using Extra tools add ins, all of the worksheets in those Excel files will be copied in desired Excel
link to purchase Extra tools add ins for Excel : https://deyako.co.uk/product/extra-tools-add-ins-for-excel/