I have a running total cell ie. cell T3 in my summary sheet. I want that cell to capture the value from a total’s cell “T6″ on a different sheets, each sheet is a copy from a master. Cell T3 on the summary can say”=SUM Sheet1,T6” for example. But when i create a new “Sheet2” then “Sheet3” and so on, how can cell T3 on the summary sheet automatically adjust to include cell T6 from each new Sheet and continue to give me a running total?
Mac Numbers version 6.0 on Mojave.