I have a few excel files, which i want to dynamically pull in from a directory based on file name. Each of these files have multiple sheets in the file. I want to union each excel file to one master excel in which each tab is a union of the data from the multiple excel files. Can someone help?
Please see below how you can do it :
Hope this helps !
Regards,