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?
