Greetings all!

Please forgive my lackluster knowledge on this. I mostly focus on systams and networking, but the office folk are trying to redesign our scheduling/tracking mechanisms which, as you can probably tell, and handled with Excel (we're a manufacturing facility, small/medium in size).

The overall structure of the different schedules is based off a central "Master" schedule (data is not manually entered to this file) which the other satellite schedules will hopefully dump their data into and pull from if needed. The problem currently is if the Master schedule pulls data from the satellite schedules, it will have to be opened to get updated data, which could result in late or inaccurrate data in satellite schedules that have shared data. If the data were to be pushed into the Master rather than pulled into it, this problem would go away.

I'm not sure if I phrased the question very well so please don't be afraid toas for clarification if need be.

Cheers, and I do appreciate the help!