VBA to incorporate a hyperlink to another tab

Hello!

I'm new to VBA and need some help. I have a spreadsheet with many tabs (one for each deal I'm working on) all based off of a Template. I click a button and this macro (below) creates a copy of the template and prompts me to rename it to my new deal name. I'm making a 'home page' to make it easier to navigate and all my deal names will be in column E. What I want is to be able to run this macro, click the deal name I've just typed in column E, create the new template tab for this deal, AND hyperlink to the tab it just made. What I'm missing here is the hyperlink part. Any help would be much appreciated!

Sub NewSheetFromTemplate()
Dim sName As String

sName = Application.InputBox("Enter the new sheet name:", Title:="New Sheet Title", Type:=2)
If sName = "" Then Exit Sub

Sheets("Template").Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = sName

End Sub