Two Sheets, Different Layouts, Both Change Each Other

[Miller9cle]

Hey guys,

Here's my problem:

I have a schedule that I have created with two different layouts on two different sheets but they both have the same information. The information is often changed and updated. The problem is that some people prefer to change one schedule, while others prefer to change the other schedule. I would like to know if there is a VBA script that I could use to update both sheets each time a number is put in either sheet so that the displayed information is always the same in both sheets.

I hope I explained that well enough.

Thanks and please let me know if you have any ideas,
Walt