I'm in charge of keeping track of Teacher/Student communication. Each student has their own data sheet where the teachers can update with new dates as they talk to students. Is there a way to pull the added date to my quick reference spreadsheet where it would replace the old date with the new date added?
I don't want all the previous cell dates just the newest one that was added.
TLDR: Teacher adds new cell with new date --> Auto update my sheet by replacing old date with new date.