Using one worksheet to pull data from many

[Sara P.]

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. $-
$-

 

[Otto Moehrbach]

Sara
If you want to place data into a specific cell in the cost WS, and pull
that data from a specific cell in a specific sheet, and those 3 parameters
(cell, cell, sheet) never change, then a formula in the cell in the costing
sheet is the way to go. There are some exceptions to this, like if you want
to pull data from a table of data for instance, or if the source cell
location is dependent on some condition that can be defined. In those
cases, a formula would work as well.
As you guessed, what you wrote doesn't make much sense to anyone but
you. Post back and give some specific details about what you want. For
instance:
In this cell I want the entry from that cell in that sheet.
Repeat this for a dozen or so cells.
If the cells are not always specific, provide an explanation of how to
determine what cell you want.
This will give us an idea of what you are working with. HTH Otto