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 SyndCo...