Variable data photo path question

I have a customer who is setting up the variable data file in excel for a large label run i am doing for them.

I have everything set up in colums and the labels will have different photos on each along with text, My question is how can i have the customer put the file path to the photos on their computer and have it show up fine on my computer when they send me a zip folder with the photos?

C:\Users\John\Desktop\Photos\Jellyfish.jpg is a example on my computer

Their file path would be different beings they are using their own computer, which would throw the variable data off on the photos

Any help?

 

Found a solution, Thanks guys.

I had a friend help me write a line of formula who is a master at excel that will allow me to put the photo path once the photo folders on my computer into each line with a simple click and drag down.