You can use "external references" to access cells in another worksheet like
this:

=c:\foldername\[filename.xls]sheet1'!$b$13

"Somewhere In Excel 2002" wrote:

Hello and thank you for your time...Here is my question. I have created an
audit for my employees performance using a rating system, (i.e. Meets
expectations, Exceeds expectations, etc) in one worksheet of Excel 2002. I
have created a drop down list for each of the ratings and a list of my
employees.

In another worksheet of the same workbook, I would like to have a report to
record both the individual employees and the ratings of each of my employees.

Can excel record these ratings for each individual separately in another
worksheet while still using the same audit form containing a list of
employees and ratings?