I would like when I change the colour of shading on a sheet for that to be recognised by the master sheet. Can anyone help.

Also can I set things up so that when I receive sheets by email they automatically enter into master. Maybe lot to ask of system but would just like to know if it can or cannot be achieved.
Thanks