How do I copy text to all sheets, sum values on last...

Hello,

I hope everyone is having a nice evening.

I have a spreadsheet that tracks funding for graduate students by semester. So, there is one worksheet for fall, one for spring, and one for summer. They are all identical in terms of formatting.

What I'd like to do is update each worksheet with the same text (names, year in program, state residency, what type of funding) to all worksheets to avoid having to cut and paste, or type, 70+ names for every semester, but also distill the summed values in each sheet to a summary sheet at the end.

I'm sure that there is a way to do this, but unfortunately I haven't had much luck in finding resources.

The template is attached, and I thank any and all in advance for any help you might be able to provide.

Best,

Gretchen