Hi, I would like to set up a costing worksheet to pull many bits of data from
every other worksheet in the book. Each worksheet is it's own seperate po and
it's set up in a printable format I guess. I would like to pull data from all
over the form i.e. P.O. #,Issue Date,UoM, etc. Is there a formula that can do
this or is it a manual thing because of the way the data is distributed all
over the place? Below is part of the template I use. I don't know if this
will make sense to anyone but it's worth a shot.

Thanks,
Sara


Purchase Order
ORDER NO. (D4&E4) RELEASE NO. Issue Date
Date Recieved (merged cell H5-J5)

ORDER FROM: Operating Center :
ATTENTION: Supervisor :
TEL: Purchaser:

Item Quantity Unit of Measure Description Unit Price Extended
Price Code #
(A28) (B28) (C28)etc. $-
$-