Here's the promised code snippet:
= Table.Combine({
Excel.CurrentWorkbook(){[Name="Page1"]}[Content],
Excel.CurrentWorkbook(){[Name="Page2"]}[Content],
Excel.CurrentWorkbook(){[Name="Page3"]}[Content],
Excel.CurrentWorkbook(){[Name="Page4"]}[Content]
})