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...