I have a main folder , in which I can have multiple subfolders which contains multiple excel files.
I have to merge files present in respective sub folders in one file. Files present in sub folder can have multiple sheets then merging will be done on respective sheet basis.
Hence each sub folder has one output merged file.
I have a solution where we can merge all sub folder files into one master file but I want to merge files present in each subfolders respectively.