I have 14 sheets in the workbook
Each sheet has names and numbers and a €˜total calls made cell which I call
from a separate summary sheet
I am tracking calls everyday on the 14 different sheets (different categories)
Yesterday I went through the pain of typing =sum(, click sheet tab, select
cell, +, click next sheet tab, select cell, +, etc.
Yesterday I made 16 calls and the above approach worked great
Today I made 3 calls
Now it doesnt work as great because I want to keep the daily totals
separate on the summary sheet without having to do what I did yesterday.

Column
J2
Row A2 16 Calls yesterday display in A2
3 Calls today
currently 19 displayed on summary sheet from yesterday in
row A2 again, wiping out the prior
number 16
would like to display 3 on summary sheet in a different cell from
the 16 prior calls, such as A4, without having
to go through typing (+, clicking
sheet tab, select cell), (+ clicking
sheet tab, select cell), etc every day.

Is there a way to do this with an automatic update from each sheet to the
summary sheet?