userform with looping code

Not to sure what your objective is but,

And also was curious how to get the Zones to show up?

Try this in B3

=IF(OR(MOD(ROW(),2)=0,B$1=""),"",INDEX(LOG!$A$2:$D$1000,MATCH($B$40&MID($A3,FIND(" ",$A3,1)+1,255)&MID(B$1,FIND(" ",B$1,1)+1,255),LOG!$A$2:$A$1000&LOG!$B$2:$B$1000&LOG!$C$2:$C$1000,0),4))

Confirm with Ctrl+Shift+Enter not just Enter

Drag Across and then Down to suit your table.

I have used conditional formatting on your sheet "User Form example" to put borders around the results

Hope this helps

[EDIT]
There are none so blind as them that cannot see!..
Just noticed your actual Userform, still the formula might be useful if you intend keeping the sheet "User Form example" as a holding template, (It could be hidden).