how to set up macro to select newly created work sheet?

greetings and good morning all, i'm in the process of trying to create a macro where I have multiple worksheets and would need to have the macro setup where when it runs, it automatically goes to the newest created worksheet name then does it's thing (which is update and revise a few pivot tables). for example, in VBA under the VBAProject window pane, theres 15 sheets, (Sheet1, Sheet2.....Sheet15). if i'm on Sheet1 and want the macro to go straight to the latest/newly created sheet name, sheet 15 in this case. later when I create a new sheet name, sheet 16 then the macro would automatically go there if its in a different sheet name. thanks in advance!

I do have a code that creates a new worksheet name:

PHP Code: 

Sub step1()
'
' step1 Macro

    Cells.Select
    Selection.Copy
    Sheets.Add
    ActiveSheet.Name = "MRFE Scuff Height  " & (Format(Now, "mm.dd.yy"))
    ActiveSheet.Paste
    ActiveWindow.Zoom = 90
    ActiveWindow.Zoom = 80
     Range("A1") = Format(Date, "mm/dd/yy")
    Range("E1").Select

End Sub 


I think it worked lol. the pivot tables that I have in my step2 macro did update to the new worksheet. I had thought the call for the demo function would go to the newly created worksheet but it stayed on the worksheet name I was on, whicih was worksheet1.

ohhhhhhhh. im still a noobie lol thanks CK76

ok I changed the Debug.Print ws.Name to ws.Select ws.Name and got an error saying "Run-time '1004': Method 'Select' of object'_Worksheet' failed
when I highlight line where the error accorded, it pointed to the very last worksheet in the file.

I would but since this is for work its sensitive material and I don't feel comfy about uploading it on the message forum. the workbook has a total of 15 sheet names and they're not all in numerical order.

see attachment.

in this case, sheet15, but when it creates a new sheet, sheet16, I want the macro to highlight sheet16.

i'll take a look. thanks CK76