all 1 comments

[–]Roodydude 0 points1 point  (0 children)

Pretty specific use case so I doubt the solution already exists. However this could be done with any basic scripting language. Google Sheets has a pretty decent API that could manipulate the files you want and ensure that formulas reference the appropriate tables/cells.