combine sheet

Hi all,

I have an excel file with 100 tabs in one file and i would like to combine them, all the files have same format and same number of cells.

I am currently using sum(firsttab:lasttab!(cell)) to sum up the total for a particular cell, the source file is not in data format and hence i unable to use power query to combine the sheet. However, it is very hard for me to trace back to check the value in each tab and i have a 100 tabs i need to go each tab to view the value.

My question is:

1) Is there any other way to check the value in each tab using the formula above?

2) Is there any other way to combine the worksheet and it is convenient for me to check back the value in each tab?