Excel formula link between sheets

I have a workbook containing a master sheet (sheet 1), and several other sheets (sheets 2 to 7) which I want to populate with colour highlighted cells that automatically appear in the corresponding cells in the master sheet.
Is there a formula/function that can do this?
Thanks

 

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.

 

Thanks for your help, I think this can work for me. I need to play around with it a bit and try it on my actual workbook, and also make sure I understand your notes.

Thanks again, this is really helpful!