I hope I am writing this clear enough for you to understand,.

We have a workbook that has the depeartment staff's 4 month schedule. Each worksheet is a different month and the last worksheet is for management only to determine staff stats on absentism and to know if extra staff needs to be called in. On the schedule sheets, there are the staff shift times and colors depending on reasoning for the shift. (e.i. stat is orange, sick is pink, shift trade is blue, etc...) 3 managers and myself have access to edit the workbook. It is password protected. There are alot of macros in this workbook. The problem we run into is that if one of us is editing the workbook, then the others need to wait till that person saves and exits before we can edit.
My question is: If I were to save this workbook on a drive that only the management has access to. Then I can "share" the workbook and we can all edit at the same time. But I would need to create a mirrored copy of certain worksheets (not all) on the staff drive so they can see the schedule with all the changes as they are being made. The mirrored copy would need to show all the data and formats of the orginal copy. I also need to be able to freeze some panes so it is easier for them to see the schedule. Also if possible, the sort feature would be nice on the mirrored copy.
Hope this is clear... Please help.