I tried to link the team names (logos) with which is a player is associated to using Named range and indirect referencing in the logos sheet of the file
steps
a) data validation
b) linked picture and name of the player
c) copied the picture and pasted it near the data validation
d) gave a indirect referencing in the cell D1 by the name pic
e) While entering the formula after clicking the picture (= pic), it is showing an error.