Hi Uthaiah,
If you have the same format of data in all worksheets (means same Header columns), then you can loop the Read excel data:
Action steps to be followed to loop read excel data using "Excel VBO"
1. Create Instance
2. Open Workbook
3. Get Worksheet Names (Save it in a collection, Ex- colWorksheetNames)
4. Loop the colWorksheetNames and read Excel using Excel VBO actions (Provide Worksheet Names in "Get Worksheet as Collection" like colWorksheetNames.Name (this is the column name you get in abouve collection ans=d pass the data in a loop for every worksheet)
You can do other actions in between for other validation/exceptions
Hope this helps