can't combine VBA elements

Hi,

what I need to accomplish is a macro that will loop to take variables from say, A1:A50, concatenate that onto the end of URL that ends in = , do the lookup., have the Destination (in plain text OK) as Sheet2 B1 and then append each other lookup in the loop in the same column on Sheet2, after the previous. Each lookup result will vary in length, I've seen a very long macro to append at the end wherever that happens, but an Offset of around 150 lines between should do. I've looked at lots of macros and can find elements to do the concatenation, loop, lookup and append, but each example is specific to another purpose and I can't figure how to put it altogether, any help greatly appreciated

mtia
Mark