Find 10th to last cell value from different sheet

[borabora12]

I have 2 sheets. One containing a list of data easily over 200 rows, I want to display the 10th to last value from column A from the sheet with all the data on the 1st sheet using a formula. The number of rows constantly changes on the data sheet. Thanks in advance.

 

[kpark91]

How about just hiding the rows from 1st to 9th values of the column?

 

[VoG]

Maybe in A1 copied down

=LARGE(Sheet1!A:A,ROW())

copied down.

 

[borabora12]

Thanks for the reply. Some values may be blank. This is a little more detail:

Sheet N = no data
Sheet D = data

Sheet N, A7 = show 4nd to last cell in Sheet D Column A
Sheet N, A8 = show 3nd to last cell in Sheet D Column A
Sheet N, A9 = show 2nd to last cell in Sheet D Column A
Sheet N, A10 = show last cell in Sheet D Column A

how that clarifies what I am trying to achieve. Thanks again.

 

[borabora12]

Actually no cells will be no blanks.

 

[Aladin Akyurek]

Actually no cells will be no blanks.

What is the exact range from which you want to have a set of records?