Adding multiple SharePoint libraries to a query

You can start with these to get the combined source tables, and second line onwards you have to deal with GUIDs, as it is tough to understand the end goal

let
    Source = Table.Combine(
        {
        SharePoint.Tables("https://URL.com/sites/who-we-are/", [Implementation="2.0", ViewMode="All"]),
        SharePoint.Tables("https://URL.com/sites/tools-to-do-my-job/", [Implementation="2.0", ViewMode="All"]),
        SharePoint.Tables("https://URL.com/sites/our-locations/", [Implementation="2.0", ViewMode="All"]),
        SharePoint.Tables("https://URL.com/sites/how-we-work/", [Implementation="2.0", ViewMode="All"])
        }
    ), 
...