Macro To Replace Formula Reference

I have created a workbook that generates new worksheets with unique identifiers as tab names. I.e. On a "Create New Sheet" worksheet, input three pieces of data, click "Create New Sheet" and this data is applied to a template sheet, macro continues running to copy the template and rename is with a unique SKU.

My problem is as follows: I have yet to figure out how to generate an Index page that is updated as each new sheet is added with the following:

a) Cell containing the SKU and a hyperlink (or some other link) to that particular tab, and
b) Beside this cell, pull the contents of certain cells from that SKU's tab (such as description, but also the contents of calculated fields on that SKU's tab like current quantity and current price).

I would like the Index to be live so that if data is changed on the SKU's tab, it flows through to the Index......