Is that possible to load and build a new master table from multi sharepoint online list.

[jerrylee]

To cope with user requirements, there are a 13 sharepoint list (same data structure) from a number of sub-sites, which collect data from difference parties.

How we have to group or load all data into a master file and deploy a dashboard for reporting. And I only have limited informaiton or materials from Gxxgle.........  

[v-ljerr-msft]

Hi @jerrylee,

Here is a similar thread and two solutions for the same scenario as yours are mentioned there. Could you go to check if it helps?

Regards