Using VBA to link Radio Buttons to Display an observation

I work in the science field and I'm trying to record an observation with some codes within a template. I have 5 different codes (A-E) to choose from and want to display the code that the person has chosen for each of the 6 compounds they are working with.
I started creating these command radio buttons with some code to display the results in part particular cell, but I would need to do this 30 times linking each group together to get what I want. I know there's an easier way to do this but I'm not sure how so I'm sending this thread to get someone's help.
Please take a look at my sheet and let me know how I can get my desired results.

Thanks in advance