Transferring data from one worksheet to another

Hi, I have a very simple problem, but spent several hours trying to find the solution and could not find it.

I have one work book and multiple sheets in that work book.

I want to transfer one cell from "Sheet 1" to another cell in "Sheet 2" That is not the problem. The problem is when I sort "Sheet 1" the cell changes and the data in "Sheet 2" stays with the original cell.

So the data in "Sheet 2" is not changing to the new location from "Sheet 1".

How do I keep the data from a cell that may move when I sort to still go to the other sheet.

This should be simple but I must be missing something.

No it is not done manually. I put data in one cell manually and I want it to appear in the other worksheet, which it does, so when ever I change the data in the first sheet it will change in the second sheet. The problem is when I do a sort on the first sheet the data in the second sheet is not coming from the place where the new cell data is located at.

This is sheet 1

DATA Formula

233 None
456 None
123 None
896 None

This is sheet 2

DATA Formula in A4

123 (=SUM(Sheet1!A6)

Sorting the data on sheet 1 will change the data in sheet 2. I want the data to remain the same data from sheet 1. Which is 123 and where it goes on sheet 1.

Trying to attach the file.

All I want to do is sort sheet one and make sure that what ever data is in cell moves to the new sorted location and is transfered to sheet 2 keeping the data that was in that cell.

I thought that this would be an easy thing to do.
All I want to do is keep the same data in sheet 2 no matter where the cell moves to in sheet 1.

No that's not what I was looking for. Just wanted to do a sort on sheet 1 but have the value that's in sheet 2 go where the new location is in sheet 1.