Hi @Jyothi_SUVERA ,
I think you should give much more details. Some questions come to mind at first glance;
- Is the folder only have these 10 excel file or are there any other files in the folder?
- Are excel files have only 2 sheets or are there any other sheets? Are sheets names specific?
3)What are the formats of data to compare?
Regards,
Emre