Hi,
I need to multiply cell C10 and E10 in each worksheet in my workbook to get total hours in Main sheet in the same workbook.
I got 30 worksheets in my workbook and these are identical.
I need to fill cell C10 in the Main sheet.
The formula is;
=Sum(Sheet1!C10*Sheet1!E10+Sheet2!C10*Sheet2!E10+Sheet3!C10*Sheet3!E10.......until the last sheet)

Is there any other way?
It will be broken if I change the sheet name and add a sheet and delete a sheet.

I know if I get a total from one cell , then formula will be
=Sum(Sheet1:Sheet30!C10)

Is there any way possible in excel that I can achieve this in formula, or Can I use a macro to do this?

Thanks