Data summary vlookup, Vba code or anything that can help

[koklok]

I need something automated here to pull the info from Statement to yellow highlighted area.
V look up , VBA code or anything that can help

Thanks

[Charles]

Hi,

This is what I came up with.
Click the Button on sheet Summary.
I hope this helps you.
You will need to expand the formula that you have in column F should you add more store location.