Merging similar data advice/guidance

[jambo2013]

Hi All

I was looking for some ideas/advice.

So in my role, we provide subscriptions to schools each year for various service areas. This is basically done by sending out a excel-made form to school who complete, send back to us and then we input into a master spreadsheet.

The past 3 years we've done this, and have now ended up with 3 spreadsheets for each year.

For data analysis such as what each schools have subscribed to each year, any regular or lost customers (all that sort of thing) it's usually a case of me manually retrieving the bits of data for each school.

I was wondering whether there is a better way for me to do this, such as merging all the previous spreadsheets into 1 main spreadsheet, which would show what each school subscribed to in the previous years.

I've attached an small example of what the spreadsheets look like.

For this, we can assume that all the school names are the same (and in the same order) for each sheet (year) - as I'll no doubt need to make sure all the names match before doing anything anyways!