get table form excel URL

You may create a custom function called fxWebData using the following query...

(url) =>
let
    Source = Web.Page(Web.Contents(url))[Data]{0}
in
    Source

And then convert your data with URL lists into an Excel Table and rename it URLs and then create a blank query with the following M Query.

let
    Source = Excel.CurrentWorkbook(){[Name="URLs"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"URL", type text}}),
    ExtractingCompanyFromURL = Table.AddColumn(#"Changed Type", "Company", each Text.AfterDelimiter([URL], "/", {0, RelativePosition.FromEnd}), type text),
    InvokingCustomFunction = Table.AddColumn(ExtractingCompanyFromURL, "Data", each fxWebData([URL])),
    RemovedTheURLColumn = Table.RemoveColumns(InvokingCustomFunction,{"URL"}),
    FinalData = Table.ExpandTableColumn(RemovedTheURLColumn, "Data", {"Column1", "Column2"}, {"Column1", "Column2"})
in
    FinalData

For details, refer to the attached.

You may get data privacy warning first time and you will need to click on Continue and choose Public from both the comboboxes.

Download Excel File

Regards,
Subodh Kumar Tiwari (sktneer)