Merge Many SharePoint Lists

[bobw53]

Hello Everyone,

I have a challenge that seems simple but is difficult to find an answer on any forum, guide, or video. 

I would like to use Power Automate to append multiple (up to 50) SharePoint Lists with identical columns into a separate, master List.

The ideal solution would look for changes to a row with the same Title and update the master List. It would also add all new entries from the original 50 Lists.

Each List may have several hundred rows and 30-40 columns. Ideally, the process would take a very short amount of time to execute.

Thanks very much.