Duplicating KUTools via macros

[Garrix]

Is the above possible (title)? Specifically the merging of multiple sheets/files functionality.

What I am currently using Kutools for:

Merge multiple files with the same sheet names into a single master sheet with all data.

basically: week 1 (mon-fri) - different data on every day, every day is a different tab. I use kutools to put each day's data into a master sheet that includes every mon-fri's data in a single sheet.

I have a semi-functional thing using kutools, however it only allows merging a single batch of sheets at once, so I still need to do a merge for every sheet in the document, and was wondering if there was a better way.

 

[Tyron]

Is the above possible (title)? Specifically the merging of multiple sheets/files functionality.

What I am currently using Kutools for:

Merge multiple files with the same sheet names into a single master sheet with all data.

basically: week 1 (mon-fri) - different data on every day, every day is a different tab. I use kutools to put each day's data into a master sheet that includes every mon-fri's data in a single sheet.

I have a semi-functional thing using kutools, however it only allows merging a single batch of sheets at once, so I still need to do a merge for every sheet in the document, and was wondering if there was a better way.

Have you tried to do what you want while the macro recorder is on. It may actually tell you how to do it when you view the recorded macro? Is there a way to create a macro that runs KuTools for you on each sheet? I have never seen KuTools, but it does sound like a decent amount of VBA is necessary