Automate cell/s with color fill

[hotrod]

I have a file with many sheets.
Main sheet, I fill cells with color where required.
I want the rest of the sheets to have the same color cells as the main sheet. What do I need to do to make this happen automatically without having to change the cells color of every other sheet.

 

[Andrew Poulsom]

Group the sheets before applying the colour.

http://office.microsoft.com/en-gb/excel/HP052024921033.aspx

 

[hotrod]

Thank you Andrew