I have a hub site that is connected to many collaboration sites. The hub site is for the "parent agency" and the connected sites are "provider agencies". In the end I would like each provider agency to enter all folks that work for them in a staff roster. Ultimately I would like the consolidated staff roster to roll up to the hub/parent site, yet each provider agency only seeing their staff. I am not sure if this is possible in SharePoint modern site.
Would the list live on the parent/hub site and then filtered by provider on the connected sites, or would the list live on each provider connected site and roll up to the parent/hub?