Copying last entry in column

Hello,

I would like to know it there is a way to copy the last entry in a column that moves down on a daily basis with new entries imputed.
For example, today my last entry might be on a6, but tomorrow it will be on a9. I want to be able to automatically copy that value(date entry) thru a forumula that will put it in a designated column on a different worksheet. I do not want to have to change the formula on the destination worksheet daily to reflect the new cell, i want excel to look for the last value in the column and do it automatically.
Is that even possible?