Combine Data from Multiple Worksheets (Tabs) into One Master Tab

also here is "your way" from the picture

let
    Source = Excel.CurrentWorkbook(){[Name="Mountain"]}[Content],
    Source1 = Excel.CurrentWorkbook(){[Name="West"]}[Content],
    Source2 = Excel.CurrentWorkbook(){[Name="Southwest"]}[Content],
    Source3 = Excel.CurrentWorkbook(){[Name="Florida2"]}[Content],
    Source4 = Excel.CurrentWorkbook(){[Name="Florida3"]}[Content],
    Source5 = Excel.CurrentWorkbook(){[Name="Souteast"]}[Content]
in
    Table.Combine({Source, Source1, Source2, Source3, Source4, Source5})