|First, a posting tip: Please click on the blue line at the end of this post and read the instructions on how to post VBA code in this forum. Thanks!|
As for your question, something seems a bit strange. You said:
"...would like the hyperlinks to navigate back and forth when I have 75 sheets to work with."
Yet your code only creates 12 sheets:
For Each mMonth In Sheets(1).Range("A1:A12")
Assuming that's just an example, I'll assume you can modify the code below to create as many sheets as you need.
You didn't provide the Name of the main sheet, so I am going to be creative and use the name Main in my code below. Again, I assume that you can modify the code to meet your needs.
This code will create a new sheet for each value in Main!A1:A12. It will also create links in Main!A1:A12 to the respective sheets. Finally, it will create a link in A1 of each new sheet back to Main!A1.
Dim srcMonth, dstMonth As Range
'Loop Through A1:A12
For rw = 1 To 12
'Create Worksheets and Copy Row
Set srcMonth = Sheets("Main").Range("A" & rw)
ActiveSheet.Name = srcMonth
'Create Hyperlink to new sheet
srcMonth.Hyperlinks.Add Anchor:=srcMonth, _
Address:="", SubAddress:=srcMonth & "!A1", _
'Create HyperLink back to Main sheet
Set dstMonth = ActiveSheet.Range("A1")
dstMonth.Hyperlinks.Add Anchor:=dstMonth, _
Address:="", SubAddress:="Main!A1", _
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.