Hi All!

I am in need of some serious help for a college project. I have created a standard excel form that is to be complete electronically by over 600 people. I would like to generate a summary sheet that collects the critical information from the form. One of the items I need to summarize is the selection choice from a drop down menu. Is there a way to reference the cell to return the selected value (it is not numerical i.e. what department your in). Also as the forms are returned they will be added into a master spreadsheet with the summary page first and then the returned forms in the sheets following. Is there a way I can reference each of the following sheets without having to reformat the formulas for each of the 600 sheets/forms? I know this is complicated and I appreciate ANY help that is provided. Thank you!