Showing data from one workbook in another.
 

Im using Excel 2000 and am trying to get data from one cell or a range of
cells, which may contain formulas (Im still building it), to display in a
cell or range of cells in another workbook.

The two workbooks are e-mailed to two different people, and are done at
different times of the month. However I want information from one to be
displayed in the other so that it saves time on typing and on supplies at
work. The first work book is a tracking log of copier use and the other is a
work book with multiple sheets, one for each day in a month. The second is a
collection of data on wasted paper, and non-used completed items from the
copier.

What I am trying to do with the first workbook is make it be predictive by
taking information from the second workbook, but a week prior, to adjust the
number of completed items needed to be printed that day and reduce the amount
of waste. This way better inventory tracking can be done with more
efficiency.