Drop down list and return values

Hello everyone,

I have different set of data (say, in Sheet 1, column A is length, column B is width, column C is height.....; dynamic data range, value can be enter in the range of A6:E9005)
I wish to return the value on the next worksheet (say, Sheet 2)as there is a template done by me.
As the template only allows me to put in 1 column of value inside, therefore I wish to create a drop down box that show either the length, width, height..... for further calculation. Only 1 column data will be calculate at every single time. The drop down box should be consisting Length, Width, or Height......, placed at Sheet2!A4. The returned value will be place in Sheet2!A6 and continue downwards.

Anyone can give me some advice on how to do it?
I don't want to use logical function (if, and, or), otherwise the template's size will be too big.
p.s. I hope the returned value at Sheet 2 could be update itself as I may replacing the values at Sheet 1.

There is a reply to me to ask for a sample workbook, i attach it today. And the thread that I posted yesterday will be deleted.
Thanks.

is there anyway to apply pivot table into it?
i try to use it, and set the labels (Length, width....) into row labels but in the end i can't use it.
i just want the drop down list to show all my labels and return only a single column of data, ie, if i choose length under the drop down list, it will only show all the values from length only.

Hello vlady,

thanks but this is not what i have expected.
the data shall fill into the first column only, that is from A6 to A9005. and the value should not be sorted in any order.
and by changing the label from drop down list, the value will change based on the selection.
based on the file that i attached, i only need 1 drop down list, inside consist of length, width, height, mass and density only.
for example, if i choose length, A6 will show 1500, A7 will show 1563.... and if i change to width, A6 will show 817, A7 will show 860....and so on.
anyway thanks for the hard work.