How would I create an integration based upon an answer?

@RightSide Health - welcome to the community. 

what you would need to do is set up another tab/sheet that uses combination of arrayformula and vlookup to scan the other files for any entries that were made on the other forms, based on the lookup value in your sheet. 

for example if you wanted to look up across 10 different sheets for new records where test_id=xxxx then  you can create the lookups and pull the data across. 

i use this type of function to create a composite report after users complete a series of 5 assessment typeforms. I use the email address (passed from registration typeform to each subsequent typeform) as the key value to link data across the google sheets. In the ‘compile report and send email form - which is simply a thank you form with a re-labeled submit button - the connected google sheet (the compiler) creates the record for the users name and email and then using the email, a series of vlookups are used to scan for the appropriate records in the other files and create the composite record of data needed to generate the output report. 

does that sounds like what you are trying to do?? 

des