Have Excel save a copy of a picture based on input

Question

I'm pretty new to this and don't really know if what I want is actually possible. FYI: I work at an architectural firm.

I have two images: one named 'valid' and one named 'invalid'. I also have an excel file with one sheet per project (number). Each sheet has a matrix with our drawing numbers in row 1 and the possible revisions (A, B, C, D...) in column A.

In this matrix I can select from a small drop down whether a revision of a drawing is valid or invalid.

Okay, so now my question:

I would like to save a copy of my 'valid' or 'invalid' image named as a combination of drawing number (row 1) and revision (column 1), saved in folders named after our project number (name of sheet). (either by button in the ribbon or upon closure of excel-file).

When I change a revision from valid to invalid in excel it should of course update the valid image to the invalid image as well.

This would be a great help in keeping track of which drawing is valid and which is outdated on building sites, since a QR code on our drawings links to the location and name of the image on our server. They will just have to scan the QR and will get either the valid or invalid image in return. (This last part is already in place, I would just like to have this automated from our excel file instead of updating one by one).

Please help!