Wow thank you georgiboy, that's beautiful, works exactly how I need it to!
I'll see how I fare with the additional shapes, but definitely solved. Certainly won't be ideal if the info in column A changes drastically, but luckily something I don't foresee.
Thank you both for your help!