How to Update the Worksheets field value based on updates done in Main Worksheet.

Hello NBVC

Thanks again ...If i use just reference the item in column A of sheets B and C and not enter the string into the formula then in worksheet "B" it is taking the refrence of "A2" column of worksheet "B" only and not of the worksheet "A".
Similarly in worksheet "C" it is taking the refrence of "A2" column of worksheet "C" only and not of the worksheet "A".
but if i enter the string into the formula then then it seems to be working ...
kindly let me know whats the problem .......as i myself don't wana use string into the formula...kindly help!

Thanks again for helping me out.