All sheets contain same format data. this is for one year and I have two more files like 2021,2022
You can use the Dynamic Input tool to do this. Alternatively, you can also consider a Batch Macro for it.
If All columns Schema is same you can try this
https://www.youtube.com/watch?v=f9JLWCaVA8w
thanks