The workflow that I am working on routs excel files to their respective macros.
With the current setup macros require configuration to have the exact sheet name listed, the issue would be when the sheet names between the excel files are not consistent.
Does a workaround exist that would allow me to have the files dynamically scanned for a sheet name?