Get value from last cell. Flipping data

[Kevin8960]

I am working on a tool/worksheet that grabs the data from a user-inputted sheet (Sheet 1). The data the user inputs can vary in length, i.e. # rows.
The last cell entered by the user is transferred to the first cell in another worksheet (Sheet 2). I want to basically flip the data from how the user entered it.
Do I need to have another sheet that flips the user's data then link that to Sheet 3? Or is there a formula/function that will invert the data?
I would like to have something that I can drag down as a formula.
Keep in mind, the entered data can vary in # rows and therefore will not always be in a specific cell.
Thanks in advance!

 

[Kevin8960]

Now I have a column that has other data related to the column with this new formula. However, this other column on the original data sheet has a built in formula, so the cell isn't necessarily blank. I cannot copy this same OFFSET(INDEX( formula as it returns #N/A.
Help?

 

[Kevin8960]

I used this formula to fill in Sheet 2 Column F with data from Sheet 1 Column H.
I also have data in Sheet 1 Column D that matches with the previous data. I need it to be filled into Sheet 2 Column E.
I can't use the same formula because Column D has a built in formula and therefore this new formula grabs a cell with a formula but no value.

Help?

 

[Aladin Akyurek]

I used this formula to fill in Sheet 2 Column F with data from Sheet 1 Column H.
I also have data in Sheet 1 Column D that matches with the previous data. I need it to be filled into Sheet 2 Column E.
I can't use the same formula because Column D has a built in formula and therefore this new formula grabs a cell with a formula but no value.

Help?

Hard to follow...

Would you post the formula which seems to return a blank?