Hi abhimails,

I think you are looking for a VBA solution. This site is close to what you want:
https://www.dingbatdata.com/2017/11/...ects-with-vba/
The idea is you can write VBA and access each table on a sheet using it's index number.

Are you sure you have 100 tables on a single sheet? Each table has a blank row and column to set it away from other data? Are you sure?