I trying to make an admin document where all rows from other documents are added automatically.
Example: Person A is typing data into this document https://docs.google.com/spreadsheets/d/1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg/edit#gid=0
Person B is typing data into a similar document
Admin is watching everything that has been typed by Person A and B in one overall summary document. https://docs.google.com/spreadsheets/d/1KIDShE_fvaO_9iP5xb0ax1v7LtGdrIU1ksou0IwEibA/edit#gid=0
Is this possible? And how?