I have an excel sheet that has all the schedules Monday-Sunday (Y's and N's) that counts the Y's vs. Total employees let's call this "My data sheet", a percentage is generated in a table which will be shared to a "Master sheet" with other offices, % on it, "My data sheets" Sat's and Sunday Column will be shared with another sheet we'll call "Weekend list", that will update when refreshed or every 30 Min, is there a way to allow multiple people in My office to access "My data sheets" simultaneously, allow multiple people to view but not edit the "Weekend list" (while still allowing it to populate data from "my data sheet") and allow multiple people to view the "Master sheet"

Thanks in advanced.

Excel 2010 btw