Can you post more info.?
Do all tabs have same type of data and do they have to be loaded to the same table?
Excel sheets will be treated as databases with each tab like a table (Sheet1 will be [Sheet1$])
So you can pull data from them just like pulling from a database.
you can use multiple flows with different tabs in each.
also you cn write a sql query to select data from tabs and union them to post to the table.