Sorting and Moving Rows in Multiple "stencil " worksheets
 

Hello, I hope that someone can help me with this problem. I have two
worksheets in the same Excel file; each worksheet has 3 columns as
shown:
Name Abbreviation Value in the first worksheet.
Name Abbreviation Comments in the second worksheet.
As I type in the first Worksheet the first two columns are directly
copied automatically into the second worksheet due to the formulas I
have placed in the second worksheet. However, if I alter the first
worksheet columns, then the comments do not follow correctly in the
second worksheet. The comments column will not stay with the correct
rows anymore in the second worksheet if I move the data around in the
first worksheet.
Can anyone offer advise?