Other than using "hardcoded" direct link formulas, eg:

In your book: Product list.xls
In sheet: January 01
you could have in say, A2:
=IF('[Wasted Paper.xls]1 1 2008'!A2="","",'[Wasted Paper.xls]1 1 2008'!A2)
with A2 then copied across/filled down to return the link values as required

Note: The above link formula assumes the source book: Wasted Paper.xls is
open simultaneously, with links to be done from a sheet: 1 1 2008
(think Excel 2003 will reject a sheetname such as: 1/1/2008)

Perhaps INDEX/MATCH might provide a better way
Check out Debra Dalgleish's nice coverage on INDEX/MATCH at her:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH
There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Teryn" wrote:
I'm using excel 2000 at work and excel 2007 at home to try to find an answer,
but I haven't found on yet.
I have a workbook with data refering to numbers of pages from a copier in a
month that is listed per day. I have another workbook that has the days of
the month for sheets, and number values for wasted product.
the wasted product numbers are in cells D2:D8. I need them to go into
differnet cell on the other workbook: K5,K15:K17,K25
Workbook one is called Product list, January 08 (as sheet 1) {Where I want
information to go}
Workbook 2 is called Wasted Paper, 1/1/2008 (as sheet 1) {where I need
infomation to come from.}

The formulas I have looked at so far have been "cell" and "hyperlink", but
don't seem to do what I want them to do. Hyperlink, from what I understand it
to do, despalys a link to the refrenced cell, worksheet, url, ect; and cell,
from what I understand, gives back coded data from a refrenced cell, not the
actual data in that cell.

Any help would be Appreciated