How To Copy Data Between Several Sheets using another sheet

[Closed]
Report
Posts
1
Registration date
Wednesday December 28, 2016
Status
Member
Last seen
December 28, 2016
-
Hi All,
I have a requirement to copy the data from source to target using macro

excel file name: Testbook1
Source sheets Target sheets
Test_Src1 Test_Trg1
Test_Src2 Test_Trg2
Test_Src3 Test_Trg3
Test_Src4 Test_Trg4
Test_Src5 Test_Trg5

LoadList sheet is having above data
Source sheets Target sheets
Test_Src1 Test_Trg1
Test_Src2 Test_Trg2
Test_Src3 Test_Trg3
Test_Src4 Test_Trg4
Test_Src5 Test_Trg5

I want to copy the data using source and target cell names('sheet names')
Total we have 11 sheets src-5, target-5,loadlist-1

Please help me on this