I have added the file as an attachment to the original post. I want the boxes populated on the front sheet to automatically populate on the following sheets when filled in. There is some conditional formatting on each sheet which I would like to keep on this sheets. The colours mean something. The problem is, when I use a formula on the other sheets to try and pull the data from the front sheet the box shows a colour. I don't want to see a colour until there is data from the front sheet to see.