Macro para que copie los datos de las hojas mensuales a una total y se renueve anualmente.

I. Hola José Luís, no soy usuario habitual de Excel, pero deseaba trasladarle la información que vi sobre su consulta por si pudiese serle de alguna utilidad mientras le atiende un experto o experta de primera mano. Le ruego me disculpe la imprecisión y molestias de tanta lectura, ánimo.

https://stackoverflow.com/questions/56269123/macro-to-automate-the-next-month-and-year-based-on-previous-sheet

https://stackoverflow.com/questions/24998958/macro-to-compare-and-copy-data-from-one-sheet-to-another-taking-a-long-time 

https://chandoo.org/forum/threads/vba-to-copy-range-based-on-month-vba-noob-solved.9631/ 

https://stackoverflow.com/questions/42503154/what-is-the-macro-formula-for-copy-data-sheets-from-monthly-name-file 

https://www.excelforum.com/excel-programming-vba-macros/1377654-macro-to-copy-formula-where-month-and-year-are-the-same.html 

https://superuser.com/questions/1035720/how-do-i-add-1-year-to-a-specific-date-once-that-date-has-passed 

https://www.excel-university.com/excel-formula-to-allocate-an-amount-into-monthly-columns/ 

https://answers.microsoft.com/en-us/msoffice/forum/all/copy-spreadsheet-to-another-tab-monthly/9d0d9a81-8f06-445d-8c2a-8155924e3a0c 

https://stackoverflow.com/questions/18604924/copy-rows-from-multiple-sheets-and-sum-values 

https://stackoverflow.com/questions/48984736/copy-excel-workbook-for-each-day-of-the-month-changing-date-in-name-and-templat 

https://www.youtube.com/watch?v=9rwp3X-veqE 

https://www.youtube.com/watch?v=8p9-3rJsyIQ 

https://www.youtube.com/watch?v=m3hfbr_9rNY 

https://www.youtube.com/watch?v=h_sC6Uwtwxk 

https://www.youtube.com/watch?v=fNurT_3X_oA