Return a value from another worksheet using an index formula

Hello, i am trying to do what i thought was a simple return value. - turns out not for me 😞 as you can see below in column b i have a set of 'dynamic' sheet names called up by a index formula. thi...