Hi Steve
Make sure you have automatic calculation turned on for the WHOLE workbook. I believe the Room Occupants Sheet is set to Manual calculation, that is why it is not updating when you change the FRONT SHEET.
Tony