Summing up everyday new entry value into a different smart sheet

edited 12/09/19 in Smartsheet Basics


Can anyone give me some idea on Summing up across multiple smart sheets new entry value in separate smart sheet please.

I can sum up specific cell values or range  but i am looking for sum of daily entered values of same column from different sheets.