Hi,

I was trying to get totals from multiple sheets but I failed.

This is what I have: I do have a excel sheet that mention outstanding totals of from every sheet (representing a client) in the same position:

Cell B50 for outstanding value A
Cell B51 for outstanding value B
Cell B52 for outstanding value C

How to add grand totals of these totals on a separate sheet?

So the result on a separate sheet:

Grand total outstanding value A from all open sheets
Grand total outstanding value B from all open sheets
Grand total outstanding value C from all open sheets

Hereby the solution should be sheet name-independent and automatically add the totals from future new sheets. It should ignore totals from hidden sheets.

Thank you for your help.

Bart