Hi guys, me again!

I'm not sure if this goes beyond the functionality of Excel (I think what I probably need is a database, but Excel is all I have to be working with!), but here it goes:

I've got a macro that runs on a number of sheets (Non Conformance Index, IANC Index, Complaint Index) that takes data from certain cells in a row and copies it to the last available row in a master sheet in the same workbook (CAPA Index). This works great for us, but we've got a problem when all the data isn't entered in the Non Conformance Index, for example, and needs to be entered and updated later. Is there any way of 'linking' the original data in the Non Conformance Index and the row with the copied data in the CAPA Index so that a macro can run to update that row rather than putting it in as a new one?

To be clear, this is what I've got running so far:

 ActiveCell.Offset(0, 4).Range("A1:E1").Select
    Selection.Copy
    Sheets("CAPA Index").Select
    Cells(Rows.Count, 1).End(xlUp).Offset(1, 4).Select
    ActiveSheet.Paste
    ActiveCell.Offset(0, -3).Select
    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = "Non-conformance"
    Sheets("Non-Conformance Index").Select
    ActiveCell.Offset(0, -3).Select
    Selection.Copy
    Sheets("CAPA Index").Select
    Cells(Rows.Count, 1).End(xlUp).Offset(1, 3).Select
    ActiveSheet.Paste
But say for example I run it a few more times and add some more rows to the master sheet, but I now go back and enter more data into the cells involved in that original operation, and need that to update the row that it copied to rather than create a whole new one. Is that possible?