Copying values from multiple Tabs of a WB into corresponding Tabs of another WB using VBA

Hi All,

I need your help in copy pasting values from one WorkBook to others. I've searched many similar posts but not able to find the help I want.

I've a workbook wth 6 Tabs and would like to copy the Values from each of the Tabs into a Report Template that has the same Tabs already existing. That means, simply copying the data from all 6 Tabs of a Workbook and pasting them into the corresponding Tabs (with Same name as in the Report Workbook) of a workbook named " Template" and then saving the same with a date and time stamp and ofcourse in ".xlx" format.

You can see the code I was trying with:

Sub NewBook()

Dim sPath As String
    Dim oWbK As Workbook
    Dim twbk As Workbook
    
    sPath = "C:\Users\s.x.chakravarty\Desktop\Test\Template.xlsx"
    Set twbk = ThisWorkbook


    
Sheets("Qualified OverDue Roles").Range("C4").Select
    Range(Selection, Selection.End(xlToRight)).Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy

Set oWbK = Workbooks.Open(sPath)

With Sheets("Qualified OverDue Roles").Range("C1")
        .PasteSpecial Paste:=xlPasteValues
End With


Sheets("Schedule Change").Range("C4").Select
    Range(Selection, Selection.End(xlToRight)).Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy

With Sheets("Schedule Change").Range("C1")
        .PasteSpecial Paste:=xlPasteValues
End With    


Sheets("Qualified OverDue Roles").Select
    

    ActiveWorkbook.SaveAs Filename:="C:\Users\s.x.chakravarty\Desktop\Test\Weekly ISDC Open Demand Extract_Build Management_" & Format(Now(), "yyyymmdd hhmm AMPM"), FileFormat:=xlNormal, Password:="", _
    WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False
    

    ActiveWorkbook.Close SaveChanges:=False
    

    
End Sub

In the above code, as soon as the copy paste is done for the 1st Tab it fails to repeat teh same activity for the second tab which is "Schedule Change", (see the highlighted code).
Can anyone please help me on this. This is very crucial for me and I would like to stop this Copy-Pasting activity alltogether.

Please help.

The 6 Tabs which are there in both the Source and Destination work books are in the same order and tehy are : Qualified OverDue Roles, Schedule Change, BP ES Qualified, SI Qualified, Data Query, Not Qualified & Provisional.

Please let me know if you need any more details.