Extrapolating data

Hi,

Attached is a spreadsheet which has a list of questions which have been answered by people in different departments of an airport. I need it so that I can easily see how many people from for example Flight Crew agreed with each question, how many disagreed etc. I have put on the other tab how I need it to look. I've been going through, putting of filters doing it which is taking ages and was wondering if anybody knew a quicker way of doing it?

Thanks in advance for any help!