Overall sheet pulling in info from multiple workbooks

I have attached an excel 2013 file which is an example of a data sheet that a Medical Practice will use to record patient reviews. There will be 44 practices involved within the project and each practice will need their own workbook.
How can I simplify the process so that each Practice workbook automatically updates a central summary sheet?
If you could help me set up one of the items below, then I should be able to do the rest.
The summary sheet should be able to report on by practice, and by a particular month and overall (note as more than one row can be completed per patient depending upon the number of medicines reviewed I only need to count this once per patient):
1. No. of patients reviewed (Column A)
2. No. of patients (and therefore %) over or under ordered (+->20%)(Column W).
2. No. of repeats (Column H)
3. Top 10 list of Drug names that appear most commonly with Column Z showing the phrase "Patient overordering and dose taken different to the computer recorded dose".
4. Savings made (Column AO)

Thanks in advance

Sean

No, I would like the reporting/dashboard to be based upon the columns listed if possible.
Thanks

Thanks for your patience Arlu1201. Sorry for the delay. It would be able to provide the data in the attached file. Hope this helps.
Sean
Sample summary sheet required - Mar 2013.xlsx