Help adding a formula into a VBA that creates a Table of Contents

I have a log that has dozens of worksheets named employees names (Last Name, First Name), I have a VBA that takes said names and creates a table of contents with hyperlinks. Now I have a formula that I enter that references those worksheets and tells me the value of a cell. But when I run the VBA to update the table of contents, the formula gets erased and I have to reenter it.

Can someone help me incorporate it into my VBA?.

Formula:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

VBA:

Please Login or Register  to view this content.