Create hyperlink exactly into drop- down list

Hi All,


I have two sheets:sheet1 & sheet2

in sheet2, I have 3 mini Tables that are the same.each of the table have named

in sheet 1 D1 has drop-down list whit three name

I need when I select any of three names into the drop-down list, I can easily use the link directly to the tables

without vb, please

Regards,
Jacob

Good News!

Finally, I could Make it for two ways

1)for three sheets
2)for three Rang

I will so glad, if you have any Idea for Improve that

Okay! I need your great Ideas

Regards,
Jacob

@BMV Thank you so much!

That is great!

Please try
List
=INDEX(Sheet2!$1:$1,MATCH(Sheet1!$D$1,Sheet2!$1:$1,))

Data
=INDIRECT(D3&"!A1")

@Bo_RY many Tanks!

I learned a lot of things from both of you. It is my pleaser!