Cell copying to multiple sheets

Hello thank you for your time reading and considering.

I am hoping to copy cells and place them in rearranged order from one sheet to another but am having difficulty choosing a function to complete the job.

Below is a sample work book.

I am trying to get 'Data' B1:B10 to populate in 'Sample' C1:C5 and 'Sample' G1:G5 in the corrosponding position to the text, and again in 'Sample 2' C1:C5 and 'Sample' G1:G5 in the corrosponding position to the text. I would like the end product to match Sample Goal and Sample Goal 2 respectively.

The 'Data' B1:B10 is already being populated by a CONCATENATE function. I am not sure if that matters but I figured I would point that out.

Please let me know if I need to explain anything further or clarify anything more.

Glenn, thank you very much for your help with this issue. I apologize for the spelling errors. I am unfamiliar with these 3 functions so I really appreciate your help with the composite formula. I will look to learn more about these so hopefully I can use them instead of asking!

Take care