The title is the best description I could give. I have no better way of explaining this. I've Googled this so many times, but I always come up empty and I'm sure that's because I don't know how to describe the issue.

Please see the attached example spreadsheet I just threw together to give a quick idea of what my other spreadsheet is like. The concept is pretty much the same.

Book1.xlsx

I'm trying to get the values from the cells highlighted in yellow (C12, F12, and I12) to fall in line in range K3:K31. And if I have to use some type of Command Button to do it, I also need to be able to make it happen over and over from those highlighted cells, because I might have to use each of those sections many times.

I hope this is making sense. If not, please ask questions and I will gladly clarify the best I can. I've been trying to do this for a couple of years and I finally decided to ask for help with it.

Thank you!