Macro to copy data and paste them into different columns under 4 different sheets

[Bimmy]

Hello,

I'm looking for a macro that can copy data from sheet1 and paste them into different
columns across 4 different sheets.

For complete explanation refer attached sheet.
__________________________________________________________________

Mod edit : thread moved to appropriate forum !​

 

[Bimmy]

Any assistance will be greatly appreciated