dynamically linking subsistent worksheets to a master worksheet

[jcontrer]

I made a workbook detailing three different hospitals that i coordinate for.
i have one sheet for all the hospitals, and one sheet for each individual
hospital with just that hospitals info in it, this totals four sheets. My
goal is to put info into only the all inclusive worksheet and have it
reflected in the corresponding hospital's list. I also want to be able to
make updates to things already in the sheet and have it reflected in the
corresponding hospitals sheet because there is a lot of info already entered
that will be updated from time to time. Can that be Done and if so, How do i
do it...

 

[dan dungan]

What info do you want in the all inclusive worksheet?