(Somewhat General advice)
It appears to me it's doable by scripting. Since you are new to InDesign automation, I would strongly suggest not to take the custom plugin route. Plugins can do *anything* but writing them is difficult, and they will need to be updated (and possibly rewritten) for every new version of InDesign, and they are platform-dependent.
With scripting, you can easily try out different approaches and test in small steps towards your ultimate goal; and you have a selection of programming languages that work directly from within InDesign (other than the edit-compile-restart ID-test workflow needed for plugins). You can use Visual Basic or AppleScript (platform dependent) or Javascript (platform independent).
![[Jongware]](/people/%5BJongware%5D/avatar/30.png?a=20686){kind=small}
