Latest questions about "sheet manage"

Does Excel have a formula I can use on my master page to look up a sheet name in another cell on the same page and then perform the usual look up, match & index etc on that 'looked-up sheet', all...