sharepoint online – Auto Update from Various Project Team Site to Another Team Site List

I am looking at monthly progress percentage of all projects in its own project team site automatically update to a department SPO portfolio list. Any reference available?
Is it something to deal with Power Automate or JSON?
Also, please share how to handle those new projects that came in every month, any auto mechanism to capture the new project and its progress into department SPO portfolio list?