hi

here are the codes i can get this to work separately with

Copy without renaming nut maintain grouped status

Sub copy()
'
' copy Macro
'

'
    Sheets(Array("Cash Up WK 1", "Weekly Rec WK 1")).Select
    Sheets("Cash Up WK 1").Activate
    Sheets(Array("Cash Up WK 1", "Weekly Rec WK 1")).copy Before:=Sheets(5)
End Sub
And

Copy and Rename but maintain formulas to template worksheet

Public Sub SheetCopy()
Dim Sh As Worksheet, TemplateSh As Worksheet
Dim ShNum As Integer, HighestNum As Integer
Dim SheetCoreName As String

' INDICATE THE CORE SHEET NAME
SheetCoreName = "Cash Up WK "

' INDICATE THE SOURCE SHEET
Set TemplateSh = Sheets("Cash Up WK")


' DETERMINE NEXT NUMBER FOR SHEET
For Each Sh In Worksheets
If InStr(1, Sh.Name, SheetCoreName) = 1 Then
    ShNum = Val(Right(Sh.Name, Len(Sh.Name) - Len(SheetCoreName)))
    If ShNum > HighestNum Then HighestNum = ShNum
End If
Next Sh

' COPY TEMPLATE
TemplateSh.copy after:=Sheets(Sheets.Count)

' MAKE VISIBLE
ActiveSheet.Visible = xlSheetVisible

' RENAME
ActiveSheet.Name = SheetCoreName & HighestNum + 1

End Sub

Public Sub SheetCopy1()
Dim Sh As Worksheet, TemplateSh As Worksheet
Dim ShNum As Integer, HighestNum As Integer
Dim SheetCoreName As String

' INDICATE THE CORE SHEET NAME
SheetCoreName = "Weekly Rec WK "

' INDICATE THE SOURCE SHEET
Set TemplateSh = Sheets("Weekly Rec WK")


' DETERMINE NEXT NUMBER FOR SHEET
For Each Sh In Worksheets
If InStr(1, Sh.Name, SheetCoreName) = 1 Then
    ShNum = Val(Right(Sh.Name, Len(Sh.Name) - Len(SheetCoreName)))
    If ShNum > HighestNum Then HighestNum = ShNum
End If
Next Sh

' COPY TEMPLATE
TemplateSh.copy after:=Sheets(Sheets.Count)

' MAKE VISIBLE
ActiveSheet.Visible = xlSheetVisible

' RENAME
ActiveSheet.Name = SheetCoreName & HighestNum + 1

End Sub
Any help would be greatly apreciated

Craig