Combine different sharepoint sites

Hello

IN Hub site, I have so many site collections and one list i.e. Attendence exist in each site collection with same structure. I want to read the data from Attendence list from all sharepoint sites. currently there are 15 site collections, in future this can be incerased. So I created a list i.e. CombineSites  which containing the site utl all those sites which Attendence list.  So whenever new site cerated, I will add the url in this list.

Current I did hardcoded as and leter I filtered list with Attendance and expanded table. I am geting all the result.

= Table.Combine(
{
SharePoint.Tables("https://mydomain.sharepoint.com/sites/PtestSite1", [ApiVersion = 15]),
SharePoint.Tables("https://mydomain.sharepoint.com/sites/PtestSite", [ApiVersion = 15])
}
)

Hub URL is "https://mydomain.sharepoint.com/Ptest".

How can I read the url from Attendance list and combine the tables ?

Regards

Avi

How can I run thru loop