Is ALL the data on the 17 sheets gleaned from that single Master sheet. If
so then you may want to consider using a Pivot table to build each of your
reports from that source data, and then anytime you update that source sheet
you simply refresh the tables as well.

If not then consider VLOOKUP or INDEX/MATCH on your 17 summary sheets to get
data from the Master sheet based on matching up variables on each of your 17
summary sheets.

Also, you are working under the misapprehension that you get the Master
sheet to PUSH data out, when in fact what you have to do is get your 17
summary sheets to PULL the relevant data from the Master sheet. Formulas
cannot change the values in other cells, they can only pull data into the
cell they reside in.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Grafur" wrote in message
...
I receive outside data with 3700 rows and 12 colums of information, text
and
numerical. I also have 17 seperate sheets and each contain some of this
master data. How do I get the master sheet to deliver the individually
needed
data to the seperate 17 sheets. Column A in each of the 17 sheets is a
name
and must be recognized by the master sheet that this row must be updated
by
it's data in column G, F, C, D etc.
This is a price sheet senerio. The cost and the name of each product comes
from outside in Excell. I have several unique price sheet in Excell that
go
to seperate displays on the floor that need to be updated via the master
from
outside.