Output data from vba as a table

No. It doesn't need a new start. There are many good ideas in your workbook and I tried to preserve them. However, the handling of named ranges was rather poor, with many duplications, and that affected the functionality of the hyperlinks.

So, I did fix the problem with the sheet list and linked the list to your formula. In the process I needed to sort out the named ranges. I used code to delete duplicates and superfluous names, and that code is still there, still working even while there is nothing to do. FYI, it deletes named ranges at A1 on all sheets, leaving only one which it sets itself - and then deletes and sets it again on each run. So, if you want to give different names to that cell there will be a conflict.

Edit 01 Aug 2018 ============================

At first I suspected your auto-naming, had a closer look at it and didn't like it because it offers no advantage over changing the name non-"automatic" It turned out that it wasn't at fault. Instead, it was the brackets Exel inserts when creating a copy of a sheet, like 01 07 18(2). Brackets can't be used in range names. So I fixed the code and attach the updated version here (previous one removed).

However, your auto-naming procedure would also have problems with duplicate names. So I revamped it. Every dated sheet now has a Change event procedure (before it was SelectionChange and you had to click on D2 to activate it) which fires when you change the date in D1. You can now enter a date in any format, like 1 July 2018 and still get the desired tab name of 01 07 18.

All of these call the Sub RenameTab in the TeachExcel module which does the work. It will give a message if the entry isn't a date or if a tab for that date already exists. It will not rename the tab if it already has the correct name, as your old code did.