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

[tmpstteacup]

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

[barryleajo]

Gretchen
Welcome to the forum.
From what I can see your worksheets are already linked and pull through the data as described in your requirement?
That aside, the fields that you mention do not seem to appear by name in the various worksheets so it is not clear what you need to happen?

(names, year in program, state residency, what type of funding)

We need more info if we are to try and help you.
barry