How to make audit trail log entries for each new row of data when multiple input at once?

I am new to VBA and have adapted code provided by user JBeaucaire on thread:
how-to-make-audit-trail-to-log-which-persons-ever-edited-an-excel-file (Forum won't allow me to post a link due to being new user)

The audit trail works great, I wanted it to bring through a unique identifier and column header as well as cell changed due to the main data table being constantly sorted by users. I only wanted changes made to the worksheet entitled 'Main' recorded - I have probably done this in a long-winded manner, but it works well.

My query is a request on how I can adapt it further. On the 'Main' data sheet a user may bring through multiple new records at a time (not a significant amount, possible max 10 rows of data). The audit trail will bring through the value in column A only for the first record. Is it possible to have it that it would bring through just the value of column A for each of the records when pasted in at the same time?
I am looking to analyse the time difference between the Sales Order being saved as complete and then brought through to my delivery planner spreadsheet.

Please Login or Register  to view this content.

Many thanks in advance

Any suggestions or can this simply not be done?

Kind regards