I have a standard template for all tabs in one workbook (there are about 100
different tabs). What is the function to sum the same cells in each tab and
carry over to a summary leadsheet?

Would this be similar to running a report?

Thank you!