Please help with this automation

I have a list of names in Column A and another list of names in Column B. Each name can occur multiple times and in either column.

In Column C are the current values of the names in Column A.
In Column D are the current values of the names in Column B.

A formula is then applied to the values in Columns C and D (automated)
In Column F is the new value of the name in Column A (automated)
In Column G is the new value of the name in Column B (automated)

In Column I is the entire list of names condensed into one column this time and only appearing once (automated)
In Column J are the latest values of each name in Column I (automated)

I now want the latest value of a name (found in Column I) to automatically appear in Columns C and D when I write the name in a new line in Column A and Column B respectively.

I have attached a before and after example of what I want to happen.

How can this be done?