Can someone please help me on this?

I have these columns on one sheet, with labels...
BR
BR
CAM
CAM
CAM
COW
COW

And on another sheet, I have each one, and what I want it to say in those column:
BR Pam Britton
CAM Joy Campbell
COW Bonnie Mohr

I guess basically like a multiple find and replace. I want to replace all BR's with Pam Britton, all CAM's with Joy Campbell, and all COW's with Bonnie Mohr. But there are hundreds of these. There must be a quicker way to do this.

I will now cease to ask, "Is this even possible?" I've found that pretty much anything is possible. You just gotta know how. Thanks for the help in advance.

Matt