List Workbook Tables And References

John asked if there was a way to create a list of all table names in the workbook, along with the underlying table reference. In this post, I'll demonstrate how this can be accomplished with Power Query and an Excel formula.

Without using VBA, we would like to create a list of these tables along with the corresponding sheet/cell reference. While we are at it, we may as well make it easy to navigate to each table by setting up a hyperlink. Plus, we want it to be easy to update if anything changes ... so maybe we need to right-click and refresh to pull in any new tables we may add down the road.

We'll let's do this thing.