I have Two problems.

Here is the situation.

I have Multiple sheets.
In Sheet 1, I have a Bunch of cells containing Sprites, no Values just sprites.
I wish to connect these cells with cells in Sheet 2 That contain numbers. (so lets say the first cell with the sprite on Sheet 1 is now connected with the cell on Sheet 2 Containing the value 001)

Next I want to force the linked cells on Sheet 2 to imitate the formatting on Sheet 1. (pretty much if the cell on Sheet 1 is Green, the one on Sheet 2 also changes to Green.)

Once that is done, I wish to link all the values on Sheet 2 To Sheet 3.
On sheet 3 I want to type in a value, and have the format of that cell change colour to match the format of the values on Sheet 2 that are Changing to match the format of Sheet 1.

The end result will be,
I can edit the colours of the cells on Sheet 1, then go to Sheet 3 and enter a value to test what colour it is.

Long story short, I have no idea how to do any of this, so I am looking for help, I have done a google search, but I can never find info that matches my needs.
So any help would be greatly appreciated.
I also understand that what I am asking for may need some VBA. (If it does, help with that would be great also.)