I require your help in Auto-filling data in specific cells of various sheets using Excel VBA ;for the purpose of computing Balance Score Card for my Team.

I would be really thankful if you can assist me with the same. This will save a lot of my time.

• Data from Master Sheet must auto-populate in remaining sheets, with the Individual Agents names.
• I have coloured the cells for 1st Agent – Akhlaq Khan. Data from Yellow cells (from Master sheet) must auto-populate in Yellow cells (in sheet name ‘Akhlaq’). Similarly, for Pink and Orange cells.
• Similarly, for remaining Agents.