I currently have a spreadsheet that contains 5 questions that I would like to
send out every quarter to different departments to evaluate different
companies. I've tried to make this survey as automated as possible by
incorporating drop downs for what quarter the evaluation is for, what
department is doing the evaluation, company(ies) evaluating, and amount of
points to be rewarded.

Is there a way to have these answers transfer into a master spreadsheet,
organizing the data by what department evaluated, company and points given
for each question. This way I can calculate the average points scored for
each company.

Thank you.

A pivot table with multiple consolidated ranges would let you refresh
at any point and give you lots of flexibility for viewing by dept,
scoring etc.

Jesse