Especially when SharePoint lists need to be kept separate for security reasons, this Power Automate flow tutorial will help you keep both lists up-to-date.

You need to upload an excel file to SharePoint/OneDrive, then you can read the excel rows using Power automate and then update SharePoint list items. How to create a list based on a spreadsheet in ...