We have been in a similar situation. We developed an Android app that would get data from one form and feed it into another in real-time. But, it takes time to build an Android app and requires expertise to link the data. For a quick solution, you can use:
- entities as @danbjoseph suggested.
- Central API, R/Python, and a cronjob/task scheduler to get data from one form and attach it to the other form. @Thalie has explained the process here.