I have a large workbook full of employee information for keeping track of employee certifications. What I am wanting to do it to link the employee certification information on different sheets to one master sheet. I have been able to create links and use the data, but when I sort the employees by last name, the links from the other sheets are not staying with the employees, it is staying with the cell reference from the corresponding sheet, therefore not providing correct information for employees. This creates a problem for me when I am adding in new employees and sorting the list by the last names. Please help.