Linking 'notes' cell to Client reference

Hi All,

Ive managed to create a spreadsheet that lists sales managers and their clients and can be updated to add new clients from a system report spreadsheet using a macro and advanced filter. One of the columns on the spreadsheet has notes on each client, the problem i am having is when I update the client list and sort it in ascending order the notes become out of sync with their respective client.
Now each client has a client ID number and I was wondering if there was anyway to link the Notes cell to a particular ID? So even after the sheet has been refreshed the notes still link to the correct client?

Thanks in advance

Not sure if this should be here..

Http://www.excelforum.com/showthread.php?t=633033