I am trying to make an Employee Evaluation form that will automatically fill in from the list I type in a seperate worksheet. Is there a way to format a cell so that it will advance to the next name on the list. I have the employees names and information on one workbook, and then the evaluations (50 of them) on a second worksheet. I am trying to add a formula to the evaluations so that I don't have to go to every cell and add the new reference for the next person on the list. So, if the Persons name is in A1 on the 1st worksheet, I would like to have a formula in the second workbook advance to the second name on the list. Clear as mud, I know, but maybe someone knows what I might be getting at.

Thanks in advance for any help.