Carl,
Try using the DGET function in excel97. It will allow you to retrive data from a table on another wooksheet.
Text below is pasted from excel help.
Extracts a single value from a column in a list or database that matches conditions you specify.
For more information and examples, click ...