Cell/Column Calculation

Calling all Macro Gurus.

Here is a task:

I have a list of values in a column (say Column Q). Everyday there are values added to this column ie day 1 has 10 values in Column Q and then day two there are 12 values in column Q, day three there are 11 values. I want to write a program that checks this column to see if any values are present in any cells and if so then they are to be added and the result given in cell A1 on sheet 2.

Is that possible?

Thanks