Multiple files as input

[imivan]

My case have a directory with 18 different excel files and at least 7 sheets in each of the file. My task is to create a workflow such that they can use it as their template in the future to clean their data, however, I have received comment that says changing the input files every time is impractical and troublesome for them and they request me to update the workflow such that they can change the input files at once by changing the directory, however, they have different naming format for most of the sheets. I have been struggling to import all of them at once due to the naming format. Is the request possible or nah, if so, how to do so?

[binuacs]

@imivan Try the attached workflow, the macro reads all the sheet names and the file names then the second macro combines these files and sheet information, you can make changes in the output

[imivan]

Hi @binuacs  thank you so much, so, what I have to do is to create multiple macro batch based on different scenarios (naming convention for both files and sheets, sheet structure, column name, etc.)?