Separate Worksheet Linking
 

I am using Excel 2003
I have one worksheet that I use to document an incident.
It must provide:
Name of person
Date
Account
Type of issue

Stuff like this - another department keeps a running total
of these events on a separate spreadsheet on a common
drive.

I was wondering if there were a method by which I could
link certain cells from my form/worksheet in excel to
theirs so that there won't be so much manual input and
risk inputting inaccurate information multiple times.

Even just pointing me in the right direction would be so
helpful. It really is time consuming this way.

Sincerely
J