Dynamic Array Of Worksheets Matching Condition

im currently using a static array to select multiple sheets at once which works alongside another Sub


Sheets(Array("Group1", "Group2", "Group3", "Group4")).Select

i have a button that creates a new sheet and names it "GroupX" X being the next number, it automatically adds on the right number by itself and it works fine...
i want it my array to be dynamic so that i dont have to manually edit the array and the macro every time i add a new sheet.

i have tried things like:


Dim MyArray As Variant
Dim Shts As String

K = Sheets.Count - 4
For p = 1 To K

Shts = "Group" + p

Redim MyArray(K) As String

MyArray(K) = Shts

Next p

Sheets(MyArray(K)).Select