How can I create a macro which will lookup values from one sheet in
another, and copy corresponding values? Example:

Sheet 1:
ColA ColB
Dogs
Cats
Pigs

Sheet 2
ColA ColB
Dogs 125
Gerbils 392
Cats 92
Pigs 423
Horses 32

I want it to look up if Sheet2 has 'Dogs' in column A, then to copy the
value in of Dogs in B2 (125)into the corresponding column in Sheet1
columnB where Dogs is listed. It would ignore gerbils and horses, but
put the values from Sheet2 in Sheet1 column B accordingly.

Thank you for your help in advance!!!