Pivot Table Survey Data Multiple Questions, 5 Responses, Calculated Feilds

Hi,

I have been trying for a few days to work out how to do this and i cannot figure it out, I have attached a sample.

On the DATA tab there is a sample of information pulled out of the survey system, there are 11 questions, and 5 possible answers for each question.

I am looking to create a table to count the number of each answers for each question.

I have put in a pivot table with what i am looking for, but i can only get it to work with a single question, and i dont really want to do 11 pivot tables!

Also, i have added a manual calculation down the side of the pivot table calculating the % Agree, is there a way to get excel to automatically to this itself in the pivot table?

Thanks in advance for help!