Get specific cell value from any of the Worksheets of the same Workbook

[Deladier]

Hello.

In my Workbook I have 4 Worksheets, named: CONTROL, Files1, Files2 and Files3.

From CONTROL Worksheet, if I type the any name of the others Worksheets in cell D5, example: "Files2", I always need to know the value of cell H16 for the specific Worksheet selected in D5, that value will be in cell E5 of the same CONTROL Worksheet too.

Any idea?

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=INDIRECT("'"&D5&"'!H16")

 

[Deladier]

Ok, I'm sorry, I already updated my info.

By the way, your solution was great. Thank you so much.

 

[Fluff]

You're welcome & thanks for the feedback.