We have a spreadsheet that is shared between several users. It is used to
track specific calls that come in.

Every time a call comes in, the user goes into the spreadsheet and enters on
the next available line some of the customer information (i.e. name, address,
issue, etc). I would like to have it that every time the user starts a new
entry on a line, that the Username, Time, Date of the change automatically
appear in the first few columns, respectively, of the new row.

I started to make a formula where the user just enters the date and then I
had a "Now" formula that would automatically enter the time, but obviously,
that "Now" time would change every time the workbook is opened.

Any ideas? I have a feeling this will be more of a programming issue (which
is fine), just hoping for something to make this spreadsheet more fool-proof.
Thanks in advance!