Hi

I am constructing a tool with ~100 sheets that will act as scorecards
and 1 summary sheet which will pull the total score info from each
scorecard.

In order to efficiently construct this tool I could use some help with
the following:

1) How can I design a macro that will modify (in any way) all of the
100 scorecards?
2) Once I have figured out #1 above, how do I reference the total on
each scorecard (same cell) to the summary sheet (into different cells)
without doing it manually.

Any help would be greatly appreciated.

Thanks