Ability to dynamically link sheets


Hello, I am guessing that this question will require coding and the API but I'll ask anyway...

Is it possible to look up the name of another sheet on a row and then identify cells in that sheet by name or position and then link to the data? Please note that I do not want a =vlookup in the receiving cell, I want to end up with a link to a specific cell in the sheet to which I am subscribing.

I recognize cells can only have one function, either linking or a formula but not both so I am prety sure this would require API work.