Can I use VBA to automate the recording of daily events?

[Will]

I have to manually add events to a worksheet everyday and update links and
dates with previous sheet everyday etc. Can anyone help me automate this
process?

Any help is very much appreciated.Thanks.
William