I'm just getting into API and am trying to familiarize myself with VBA. I essentially like to know if this is possible:

A macro that can scan/recognize(or something close) that a revision has been made to the drawing, accept that input (rev change, rev description, etc) and push that to other drawings that are referenced to that same part/assembly. This would be useful as I frequently have to make revisions to one part that requires multiple drawings for tooling and the like and would like to minimize inputs and mouse clicks required.

I'm sure I am out of my depth when it comes to what I want the macro to do and my nonexistent expertise in VBA. I would just like to know if this is possible before moving forward with development.

I have scanned the forums/google to find a similar macro with no luck.