Match TOTAL word across sheet and merging TOTAL amount for each sheet based on sheet name

Hi
I have this sample file contains small data . in RESULT sheet I write sheets names in column B. so I want macthing with sheets names and merge amount in column (TOTAL) for each sheet and populate in column C. th column TOTAL will change in location so should match TOTAL word is existed in header with exclude row contains INVOICES TOTAL in last row for each INVOICE from th merging if it's existed in any sheet.
every time I add new sheets and change TOTAL column in location .
I want looping in spcific sheets . not all of sheet in workbook because I have others sheets I don't implementing for them.
don't touch any formula is existed in column C .
I look forward from the experts write smart code espicially if the data could become big in (8000 rows for each sheets

So how do we know which sheets to include/exclude?

just put sheets in array like this
("SVS","CDV","STOK")
thanks for th formulas , but I want vba .
I don't want changing range in the formula when change TOTAL column in location every time.
thanks .

I took a slightly different approach using VBA

Please Login or Register  to view this content.

The code loops through the sheets (but not the last one as it is the results sheet)
Looks to see if the sheet name is on the results sheet, if it is then it totals the values

@jdelano
thank you so much.

I you looked at the formula you will see there no need to change any range as they are full columns.

well if I have add new sheets with new location for TOTAL column I should write new formula for new sheet !
any way thank you.