The template works by entering the path to the folder (C: \ Users \ …) in the cell.

Then you update and the data from all the excel in it will be merged into the resulting green table.

Download template