Hi @BrankoJ,
According to your description, I create a Flow as below, you could follow it to structure your Flow to approach that:
1. First of all, you should store these child excel files into a separate folder that only contains these child excel files, and master Excel store in another folder.
2. Use Get files action of SharePoint connector to get these child Excel files identifiers;
3. Then Create Apply to each 1 to loop these files;
4. Use Get tables to get each file's tables to get Excel table name;
5. Create Apply to each 2 to loop these tables;
6. After we get Excel file identifer and table name, we could use List rows present in a table action to get rows from a Excel table;
7. Then create Apply to each 3 to loop these rows and add these rows into master Excel table;
8. After all loops, these rows in child Excel files will be appended into master file.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
