how to append the multiple sheets of excel file.

[bethamsetty]

All sheets contain same format data. this is for one year and I have two more files like 2021,2022

[caltang]

You can use the Dynamic Input tool to do this. Alternatively, you can also consider a Batch Macro for it.

[BRRLL99]

If All columns Schema is same you can try this

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

[bethamsetty]

thanks