For the report Monthly Centre Summary - PDF, if this can be converted to Excel and then on each tab have the centres under the filter brand. Or add the brand as a filter for the PDF and they each create on one page