Automatic file filling from another Excel file

[pierre_bonnet]

Hello all,

Here is a small summary of the situation:

I have two files, a source file (several dozen pages) and a final file (several pages as well, with a layout similar to the previous one but more refined).

I would like to automate the filling of the second file. What are the possibilities available to me?

I am attaching one of the tabs of the final file. All the tables which are materialized there exist in the source file but are present on different pages or contain more columns.

Thank you in advance for your help,