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:

Please Login or Register  to view this content.

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.