I have a workbook with a over 10 worksheets,I have one
sheet I call the Master, I would like that any changes I
make to it are reflected in the other worksheets only if
the are effected by the change to the master, eg on the
master sheet I delete a game from the Atom's but make it a
practice for the Peewee's, I need the game to be removed
form the atom worksheet and a game inserted on the peewee
worksheet, right now I do this manually i know there's got
to be a easier way, with only doing my work on the master
sheet. any help would be greatly appreciated.

If those other worksheets can be generated from the Master
based on the value in a column then you can probably do away
with them and use a filter. Top row should have titles for columns.
Ctrl+A, Data, Filter, AutoFilter
to remove all traces of the filter (like if you don't like this)
Data, Filter, AutoFilter

More information on Filters
Excel Filters -- AutoFilter Basics (Debra Dalgleish)
http://www.contextures.com/xlautofilter01.html

You *pull* values from other places in Excel, if you try to think
in terms of *push* values to another place you will cause yourself
a lot of extra work. More specifically the main thing used in
a spreadsheet are formulas and constants. The formulas are
functions, and functions cannot change anything in any cell
including itself. All a function can do is return a value.

Usually when you have a Master you summarize detail from
other places. An Example of summarizing data from
specific places in other worksheets see
Build TOC Another Approach
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"hockey nut" wrote in message ...
I have a workbook with a over 10 worksheets,I have one
sheet I call the Master, I would like that any changes I
make to it are reflected in the other worksheets only if
the are effected by the change to the master, eg on the
master sheet I delete a game from the Atom's but make it a
practice for the Peewee's, I need the game to be removed
form the atom worksheet and a game inserted on the peewee
worksheet, right now I do this manually i know there's got
to be a easier way, with only doing my work on the master
sheet. any help would be greatly appreciated.