Copy to next available row on sheet b based on cell value change

[Sharonca]

Hello,

I don't know if this can be done but I thought this forum would be the best place to get assistance or tell me that it is not possible. If it can be done I don't know how to go about getting it done.
I have two sheets:
CPM Tool
Bulk Update

I would like to do the following:
A) Copy from the CPM Tool anytime a value changes in any of the columns listed in the CPM Tool sheet to its corresponding column in the Bulk Update sheet to the next available line
B) Copy over the CPM Tool Ticket ID for all the column changes to the Bulk Update sheet.
C) Include the date, time & who changed the value in the last column of the Bulk Update sheet (Column I).
- I have the following code in my macro that generates an email when a cell value changes in a cell in a column and would like to know if I can do the same to populate Col I in the Bulk Update sheet.
Format$(Now, "mm/dd/yyyy") & " at " & Format$(Now, "hh:mm:ss") & " by " & Environ$("username") "

Ticket ID: (CPM TOOL: A / BULK UPDATE: A)

Region: (CPM TOOL: F / BULK UPDATE: B)

Schedule Date: (CPM TOOL: AC / BULK UPDATE: C)

Survey Completed Date: (CPM TOOL: AF / BULK UPDATE: D)

Installation Schedule: (CPM TOOL: CS / BULK UPDATE: E)

Installation Start: CPM TOOL: CV / BULK UPDATE: F)

Installation Complete: CPM TOOL: DA / BULK UPDATE: G

Installation Notes: CPM TOOL: CZ / BULK UPDATE: H

Date/Time/Who Changed Value: BULK UPDATE: I


Thank you in advance for any assistance

Sharon "Flummoxed in Mesa, AZ" C.