You can't "pull" an object to a new sheet without a macro, but you may
be able to use an alternative technique:
Looking up and displaying a picture based on a cell value
http://www.mcgimpsey.com/excel/lookuppics.html
> I am trying to link a picture to a cell so when I do a v-lookup on another
> sheet it will pull the picture to the new sheet.