Sara, my recommendation would be to set up a template page with
established column headers, below which you could dump the raw data
from the survey.  Then use Excels, Insert > Name > Create menu item to
name each column all at once.  Finally, create formulas and analyses
based on the named ranges in other worksheets.  All your tables and
charts should automatically update.  The key here is that the analysis
doesn't change from survey to survey.

I'm not sure what to tell you if that's not the case.  You could, I
suppose, create some VBA that leverages the named ranges and drown down
boxes that would select "operations" like average, median, high, low,
frequency tables, etc. and then have the code generate tables and
graphs, but that seems like overkill.

ryan