Dynamically linking subserviant 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...

 

[JW]

Can be done with VBA or with formulas. I would just suggest using
some standard =reference formulas in combination with VLOOKUPs,
SUMIFs, COUNTIFs, etc. Hard to give much more info without seeing the
data itself.

 

[jcontrer]

what is the simplest form. I could show you a sample if you think it would be
of help for you to explain. please let me know.