How to record and save excel changes

Hi All,

I want to record and save all the changes done in excel sheet in a separate tab or a output file, i understand that there is a inbuilt feature in excel by which we can keep track of all the changes, but beside copy pasting the changes is there any other way to directly save whatever changes happening to the excel to a separate workbook or may be in a different tab at the same time all the changes should be highlighted in the main excel sheet.

I am attaching the test excel sheet and the snapshot of what i require

Regards
Santanu

All changes made in sheet Data recorded @ sheet Log

For the WorkSheet

Please Login or Register  to view this content.

For the WorkBook

Please Login or Register  to view this content.

Kind regards
Leo

Thank You so much Leo

for sheet Data

Please Login or Register  to view this content.

Userform with codes in file

Kind regards
Leo