Use VBA to transfer automatically data from excel file 1 to excel file 2 -

Good afternoon to the community,

I want to build a table in the "consolidation 2" file that can be completed and extended automatically with VBA.
The objective is to be able to fill content in the file "Consolidation 1" and to see the automatical integration in the file "Consolidation 2".

The "Consolidation 1" file is composed of indicators that enable to understand which content will be deleted, modified or added in the "Consolidation 2" file. This part is located in the cell range B14:AX17.
The rest of the table includes the data under management. These data are stored in the cell range C18:AX19.

Consolidation 1.png

In the "Consolidation 2" file, the elements filled in yellow correspond to the elements coming from the "Consolidation 1" file.
For information, in the file "Consolidation 2", the data in the column S musn't exceed "31/12/2024".

Consolidation 2.png

Thank you for your help.

-------------------------------------------------------------------------------------------------
The "Consolidation 1" table could be expanded by adding lists of data in a second step.