diesen code kann man doch bestimmt vereinfachen
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address(0, 0)
Case "A1": Sheets(3).Name = Target.Text
Case "A2": Sheets(4).Name = Target.Text
Case "A3": Sheets(5).Name = Target.Text
Case "A4": Sheets(6).Name = Target.Text
Case "A5": Sheets(7).Name = Target.Text
Case "A6": Sheets(8).Name = Target.Text
Case "A7": Sheets(9).Name = Target.Text
Case "A8": Sheets(10).Name = Target.Text
Case "A9": Sheets(11).Name = Target.Text
Case "A10": Sheets(12).Name = Target.Text
Case "A11": Sheets(13).Name = Target.Text (Es soll bis Zelle A75 gehen)