Currently I have 4 worksheets on my workbook. I am looking for the tutorial
about how to calculate the different worksheet. Meaning, how can i add up a
specific column of this 4 worksheets. For example,
worksheet 1 column 3 have the value $50
worksheet 2 column 3 have the value $100
worksheet 3 column 3 have the value $50
worksheet 4 column 3 have the value $30

The total is $230

I know I can just put on the column $50+$100+50+$30 = $230 BUT
when i make changes on worksheet 3 value $100 then I have to change
50+$100+100+$30 =$280.

Do you guy have any suggestion how the worksheet change will automatically
change the total value column when other worksheet value is change?

Please give you precious advice and suggestion. i would very appreciate.