I have the following Sumif formula, which works fine.

=SUMIF('South Central'!E:E,summary!$C$1,'South Central'!B:B)


Is it possible to reference a cell that has South Central typed and the
formula use the sheet name and still work properly? I have a large
spreadsheet with numerous sheets to summarize. Referencing a cell for the
sheet names I could copy the formula rather than having to type all the
individual sheet names.

Any help is appreciated.