Help!!!

I am trying to change the data within my comment boxes dependant on the cell
value and if the source changes.

In my workbook I have 4 worksheets

Sheets 1 - 3 are my data sheets where the values can change

Sheet 4 is my working sheet where I want comment boxes added to each cell
dependant on the cell value. Ie if Cell A1 = F then a comment box should be
added which takes the comment from Worksheet 1 cell A1. etc etc etc
However I also need any updates on my data sheets to be shown in the
comments boxes on worksheet 4.

Any ideas please .... ???

I hope that makes sense, if not please say and I will try to clarify it better

Thanks in advance

Mike