Hi again!
So, I did google this problem and spent some time looking at solutions, but none did what I really wanted so far:

I'm building a code that will do the following:
After I input the data on a form that will be my first sheet ("Data"), I want a macro to copy this sheet, rename it after the string on "C3", create a list on my second sheet ("List"), that will keep adding these names (string data from C3), and hyperlink this name on "List" to the sheet that was just created and has the same name ("C3").

I've managed to create the macro that copies the sheet and that creates the list, but I'm having trouble with naming the new worksheet and with the hyperlink thing... my code create copies of all the sheets on the workbook, and that isn't good.

Can someone please help me out? I don't know if it's really clear...
The code for the copying and renaming I'm trying to use, with no sucess so far:

Dim cell As Excel.Range
Dim wsWithSheetNames As Excel.Worksheet
Set wsWithSheetNames = Sheets("Data")


For Each cell In wsWithSheetNames.Range("C3")
Sheets.Copy after:=Sheets(2)
On Error Resume Next
ActiveSheet.Name = cell.Value
If Err.Number = 1004 Then
Debug.Print cell.Value & " already used as a sheet name"
End If
On Error GoTo 0

Next cell

Thanks a lot! Cheers!