File union

[CloudDuck]

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.

[Qiu · Accepted solution]

@CloudDuck 
How about we read the contents from File 1 and FIle 2 and read only the File Path of Main File then use the Output Data Tool to append Sheets "File 1" and "File 2" to the existing main file.