"an you link two worksheets so that if you enter anything anywhere in a cell on sheet 1 and the same words appear anywhere in sheet 2, then the cell in sheet one will change colour, or the font will change color?"
yes this is possible using Conditional Formatting.
"What would be better would be if it was possible to use the entries in two adjacent columns, ie, a surname in sheet 1, rows 1 to 4, col B, with his current year's image titles in col C, rows 1 to 4. On sheet 2, his name and entries could be on any row at all, but still in cols B and C."
I am sorry but this means nothing to me - can you explain?