Selecting and Copying Columns Based on Combobox Selection V2

[J3Xtrom]

Hello again Excelforum!

A couple of months ago, I asked for help with an issue I was having with some ancient spreadsheets converted over to excel. The solution I received worked for the most part, but the issue of inconsistent formatting kept coming up, and I had no idea how the code actually worked. Last time my data was very inconsistent, so it was super difficult to select things properly without some blank space ruining everything.

Now I've redone the entire data sheet and everything should be uniform. We have a location name and a block of info about their purchases surrounding them. I tried reusing the solution to my old problem, but I couldn't really grasp what the code did in the slightest. Would someone be able to help me out?

Essentially I want to:

1. Take a location name from the combobox (Pulling from the list directly below it)
2. Pull all the relevant info from the shipping register into the correct columns on the packing list (Everything that has a colored background)
3. Have the code be easy enough to tweak in case we get new locations or the formatting changes

Hopefully this all makes sense. Thank you very much!