Data Aggregation Macro over Multiple workbooks

Hi Everyone.

Hoping someone can help me with a rather robust macro that I am trying to create to help automate a process. Let me lay things out in best a summary fashion as possible.

I will be receiving 50 plus files from users

Each file will have one worksheet in it...the worksheet will have 10 rows with relevant data that I would like to copy and consolidate into another tab. The caveat is that the files I receive back are from a district level so some of them might have 10 rows of data, while others will have multiple branches that roll into the district so 10 rows of data...then a blank row...then 10 more rows of data....and rinse and repeat depending on how many branches are in a district.

Right now, the process is manually opening ever file and manually dropping the results into an aggregation file but would love to create a macro of sorts that does all the work for me to avoid the human error element of copy and pasting items.

Thanks for your help and assistance.

Per notes, I have included a sample version of the excel file. Please note the following:
rows 1 through 25 are basically aggregate results that I don't care about
cell B27 represents the name of a location that is part of the total region. I would like to copy the location name (cell B27) and then all yellow highlighted cells within that section and paste over to a new "Aggregation" workbook so that I have a flat file with all of the results. If my math is correct, each location results that are dropped into the "aggregation" workbook will have 36 entries
In the sample version that I have attached, row 27 has the results for the first location and then the entire survey is replicated again starting on row 60 for the next location within the region. In some cases, there might only be 1 location for that survey. In some instances, there could be +10 location results that will all need to be copied and pasted into my aggregation workbook.
All files will have two tabs...one will say instructions (nothing to do with this) and one will have the location name, which will also be part of the file name.

Please let me know what additional information would be helpful to provide.

Thanks!