Hello,
I need assistance with a problem I'm facing while working on a macro. I'm trying to append the sheets from "File1" and "File2" to the sheet in the "Main file." ( the main file which will eventually be connected with another workflow that's why i don't just merge all 3 files from the directory ) I've attempted a solution, but it's not entirely correct, and now I'm stuck at the part where I need to combine the main file with the other two files that are already combined, perhaps not with the right logic. Please refer to the "result file" for the output.
Thank you.
