I'm using Excel 2007.
I've attached a sample workbook of what I mean (its not the one I'm actually using). Sheets 2, 3, 4 and 5 (named 'Tom' 'Dick', 'Harry' and 'Bob') are each populated with a name, and a grid of red green or yellow coloured cells, and that data can change. The data is different in each sheet, although the range of cells is the same in each sheet. As the cell grid is populated/changed, I want that information to automatically populate sheet 1 'Master' in the same format, with the information for 'Tom' first, then 'Dick' beneath, and so on. I don't want to copy and paste, as the actual workbook I'm using contains a large amount of frequently changing data. So basically, I just want sheet 1 to be read only.
Hope that makes sense. Thanks for your help.