This is possible, but it can go awry very quickly.

I would think that it would be macro based (event changes) and if macros were
disabled or even just events disabled, then you'd soon fall out of sync.

And if you made a typing error, you may lose data that you didn't want to lose!

I like to keep my data in one spot and then use Data|filter|Autofilter to
show/hide the stuff I want.

You may want to look at View|custom views, too.

And if you're really serious about having separate worksheets, I'd use a macro
to split the data--but it would be on demand. I'd run that macro when I was
sure I was ready. (I'd give up on the update automatically version.)

If you think you like the "on demand" suggestion, Debra Dalgleish has some
sample workbooks that do this kind of thing.

Maybe you can steal some code from he
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

BLM wrote:

Hi,
I have several worksheets which contain the same names but different info.
I want to be able to add and delete names in one source file which will
update the
other worksheets, sort in alphabetical order and keep the same data in all
the worksheets linked to the right name.
Thanks

--

Dave Peterson