Insert Picture into header based on sheet name

[megalamchops]

Hi, I'm not sure if this is possible.

I have a folder full of pictures (.png). I want to make a 1-click button macro to insert the picture into the header based on the sheet name. So for example ill have a button on sheet1 and if i click the button, it will insert sheet1.png into the header of sheet1. If there is an alternative way I'm all ears! Thank you!

 

[rollis13]

Just to add missing cross-post link: LINK