Transferring Data Automatically in same Worksheet EXCEL

Hello,

I'm finding a difficulty in transferring data from a number of cells to a table automatically. What I'm trying to accomplish here is that when a number of cells are filled with data the same data that is being inputted is being also filled in another cell, (using the substitute function).

Where I'm finding a difficulty is when erasing the original data from the original table. What I want is that when I remove the original data, the data that has been copied automatically in the other cell's table is transferred and saved automatically in the row below.

How can I attach this document for your reference? Thanks guys!