JLC wrote...
I have a field observation report that will be done daily be field
supervisors (see attached).
....

No one in their right mind opens workbooks from strangers. Describe
what you want in plain text.

That said, what you describe would be much better implemented as a
database application. Automatic batch updating of related existing
workbooks - data, formulas or layout - is a HUGE pain and pretty
unreliable. You can try, but I'd bet your boss will be very
dissatisfied with the result.