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.

This is possible using Power automate flow. 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.