Extracting data from summary tab to different tabs based on criteria

Hi Guys

Hope all is well


I need some help

Aim - On the “RM Monthly by rep code” Column A there are “Rm Codes”, These RM codes, are populated on the relevant tabs
I want the data to remain on the “RM Monthly by rep code” but then replicate the relevant RM code data on the relevant tabs

For eg tab “R04” has been provided with example data


Hope this explains my situation, Looking forward to your help