Summary sheet for questionairre

[danob63]

Hi,

I have a questionairre with various sheets relating to various patients. I would like to summarise the results on one sheet. For example, for 'Week 1 Question 1' I would need to pull the answer through from Patient 1 onto the sheet, and then add patient 2's answer when completed. The answers are already pre-defined in drop down menus. Once I have a few I can then create bar charts based upon this data, however my initial problem is which is the best way to pull through the data from multiple worksheets.

Any help would be greatly appreciated.