Connect values from sheets to a drop-down list

Was duplicating the formulas for each cells down the row and it was a never ending work. Was trying to use your INDIRECT formula and attach a VLOOKUP instead. For this I created a depended drop-down list which I wanted to connect to the VLOOKUP. So in other words I will get on drop-down lists where its possible to choose which sheet to extract values from and another which makes it possible to choose what type of value to show.

Have been trying to get it work but get the Reference error all the time. Is it possible to do this? See pic

\1