MACRO using VBA for contract tracking

Hello -

If anyone could help, I would be greatly appreciative. I am building a tracker for contracts that will be updated frequently by different users. I want to capture the updates to each contract which are reflected using a VBA macro:

User
Contract No.
Organization
Status of Contract
Status Date

As a new status is entered by a user for each corresponding contract, I want to create a log of the changes. Note: some columns have a drop-down list - I don't if this matter or not.

How can I do that?


Thanks!!!!