dynamic source data - best way to change formulas automatically?

Good afternoon -
On my summary sheet – I have concatenated columns from the subsequent worksheets as well as formulas to calculate the percentages. I have dynamic source data - the # of rows per MD changes, depending on the number of patients seen within the timeframe report was run. Rather than having to modify the formulas (Cols. E-O) manually on a weekly basis – is there a faster way to do this? What is the best way to change the formulas automatically?
Please see attached excel spreadsheet.Thanks!

esanchezz;

Here's something that will get you started. Copy of Sample-File.xls
I changed the color of cells on Summary3 and Test1 of the cells that I added or changed.
I'm not comfortable with array formulas, but you should be able to figure them out yourself.