Finding and copying data from one sheet to another

Hi everyone,

I'm new to the forum and new to VBA as well, so I really hope that I could receive good advice and help here from seasoned/experienced programmers.

If you refer to the attachment, basically what I am trying to do is to retrieve information from 'ClientDB' and plucking some of those data into 'UpdateClient'. However, I don't know how to write any code to read the cell-link and trigger a macro for the correct company. When I tried to record a macro, what I did was to copy and paste data from 'UpdateClient' into row16 of 'ClientDB'. But this is terribly flawed cos it doesn't lookup the correct client in ClientDB and effectively wipes out some other client's details.

Is there a way to rectify this and could anyone help, perchance? thanks in advance!!!

sab