Getting a picture in 1 sheet to another sheet based on a name entered in the target sheet

I am new to the forum, but I have some self-taught experience with Excel for both Mac and PC. I have a member master sheet and a picture sheet with photos in Column A and names in column B. I have created a form in which I write or paste the member name and the form populates with all the member information. I want the member's photo to appear in the sheet as well. The photos are sitting on cells, not in them so I have not found any way to make them appear when the form populates. I haven't used macros yet, but would be able to adapt/use one with a bit of learning. However, is there a way to create a formula that would accomplish what I want? Any help is appreciated.