|The one thing I'm still curious about is what you mean when you say "suppose (sheet1! B2)" AFAIK, a picture inserted into an Excel spreadsheet isn't really in a cell, it's just "on" the sheet. However, I'm always willing to learn so if you tell me otherwise, I'll believe you, after I test it. ;-)|
However, the following thread discusses using VBA to insert an image - directly from a file - into the header. The code could be modified to pick up the path and filename from a worksheet cell or cells, instead of having the path/filename hardcoded into the macro. There are multiple ways to build the path/filename within VBA, so with some more detail I might be able to offer some suggestions.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.