I'm at a loss over something that I am sure is so simple.

I have created a 'master' worksheet that is used to enter data which is linked to another that can be viewed and filtered by users. The contents of both sheets are identical.

I have been asked to include a picture that I enter into the foot of the 'master' sheet daily so that it appears on the users sheet too.

I have been using the camera feature as the picture is a combination of three parts of another sheet that needs to be manipulated manually daily.

How do I put the picture in the master sheet and have it appear in the users spreadsheet ? (Please bare in mind that the filters will be used yet the picture needs to appear at the bottom at all times.)

Your help, as always, is hugely appreciated.