Read file

[CloudDuck]

I need assistance in creating a macro with the following functionality:

1. The macro should take two inputs:

   • Input A: A single .xlsx file containing one sheet.
   • Input B: A directory containing multiple .xlsx files.

2. The macro should display a list of available files in the directory specified by Input B.

3. The user should be able to select any of these files from the list to append their content to the file specified by Input A.

4. Each appended file should be renamed appropriately within the macro.

[griffinwelsh]

I am not sure this is possible with a macro, but here is an analytic app that should work. You just need to update the directory path with your own. Note: this will take the sheetname from the sheetname of the file you are copying from. Fair warning: it will overwrite any sheet with the same name in the output.