I have a script I wrote for my AppSheets app that generates construction reports and compiles information from 5 different sheets into a google document template. It sorts data based on a uniqueID that is consistent throughout the 5 sheets. I have an entire workflow built into the script that allows for error checking and manager approval of employees entries.