let us question by question.
"I want to have a macro set up that allows users to click in a cell, type in data and that whatever was typed in creates a sheet named whatever was typed in that cell, and hide it from view. (will need to run this macro on sheet 2 through sheet 11).
open vb editor (alt F11)
hit control R
you see name of YOUR WORKBOOK
under the name click "thisworkbook"
a window opens
in that window copy this EVET CODE and the FUUNCTION.
save the file as macro enable. close and open and enable macros
I presume there are some names in column A of each of the sheets
select any name (you need not click anything)
see what happens.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Dim shname As String
Set Sh = ActiveSheet
If Target.Column <> 1 Then GoTo enableevents
Application.enableevents = False
shname = Target
If SheetExists(shname) Then GoTo enableevents
ActiveSheet.Name = Target
ActiveSheet.Visible = xlSheetHidden
MsgBox "new sheet opened and hidden "
Application.enableevents = True
Function SheetExists(SheetName As String) As Boolean
' returns TRUE if the sheet exists in the active workbook
SheetExists = False
On Error GoTo NoSuchSheet
If Len(Sheets(SheetName).Name) > 0 Then
SheetExists = True