How can I make sure that the data in one row stays together? For instance, I
have a worksheet (lets call it AA) that links it cells to data in another
worksheet (lets call it BB). Both maintain an employee's name and phone
number. If I add a row in the BB worksheet, then AA still links to the row I
originally put in the function, thus linking the wrong name to the wrong
phone number...

??