Appending rows (Automation) in in Excel

I have an Excel workbook containing two worksheets:
1. Risk & Opportunity Register
This sheet includes the following columns:
• Review Notes
• Next Review Date
• Review Outcome
• Reviewed By
• Review Date
• Risk ID
2. Risk Review Log
This sheet contains the same columns:
• Review Notes
• Next Review Date
• Review Outcome
• Reviewed By
• Review Date
• Risk ID
I want the following automation:
Whenever any of the listed columns are updated in the Risk & Opportunity Register, the updated row should automatically be added to the Risk Review Log, without overwriting any existing data in the log. The new entry should simply append to the next available row.

And the same process should be applied to the second workbook titled Quality Objectives KPIs Trackers and Review Log.
The columns in this workbook are:
• KPI Name
• Review Date
• Comments
• Review Name
Please note that the Notes column from the source sheet is mapped to the Comments column in this workbook