consolidating excel sheets with different colonne lenght

hi,

I wonder if some could help.

I am trying to save time with the procedure with have now. 

Each year we use a different Excel sheets for the dairy entries (like SyndConta2019MSFT.xlsx and SyndConta2018MSFT.xlsx attached).

At the end of the year we copy paste the results on a global sheet (like SyndConta_2014-2021_Global_v3).

And we keep on doing this year after year. However, if we find something to change in any of the sheets, we have to go back for all the previous single sheets and make a lot of changes.

I wonder if it would be possible using a power query command or any other idea you might think, that could link the single sheets to the global one so that any change done in the yearly ones is automatically transmitted into the global one.

Thank you very much, Juan