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!