macro creates new sheet and names it, need to create hyperlink to new sheet on main sheet

I have a workbook I've made that takes a sheet used as a template, copies it and creates a new sheet, and names the new sheet based on the input of a user form textbox. It also takes that input and places it in a cell ("A7") on the main page (page named 'Main')

I need to then create a hyperlink in that cell on "Main" for the new sheet. The new sheet name will always be on sheet("Main").range("A7")

Everything works fine except this piece of code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The subaddress needs to read (including quotes, and 'name' is the sheet name which will be different every time)
"name!A1"

*to answer questions before they're asked
-The macro will be used to create several sheets
-it will be updated often, and new sheets will be created via macro so manually creating hyperlinks to the sheets isn't optimal

here are the relevant lines of code:

Please Login or Register  to view this content.

Don't use variables that are proprietary to excel like "Name"
Change references as required.

Please Login or Register  to view this content.

Have a quick read here.
https://docs.microsoft.com/en-us/off...c-naming-rules