Glenn Mulno wrote:
I want to pull in an
exact replica of what is in the other sheet - formatting and all.

Edit / Copy
Shift+Edit / Paste Picture Link

if you want to use the content of the pasted cell then also Edit /
Paste but position the picture over the cell.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup