An artist has revealed what it was like working for the Queen on multiple occasions, including his final meeting with her just weeks before her death