VBA to Create a Roll Up Summary Sheet for multiple sheets with variable amounts of data

Hello,

I am looking for a VBA to create a Roll Up Sheet for multiple sheets in a workbook. I have 20 locations that all have a report that they are to fill out. One of the requirements is to list things they have done to improve their locations. There is no set amount of things they can list so I want to create a roll up sheet that has all the locations along with all the name of the location. There is other information on the report that I do not want to bring in. The information I want to pull in is in cells A35-B45 which allows them for 10 potential improvements. The reports are formatted as such:

where "Loc" is in cell A35 and "Improvement" is in B35. All the XXX will be the same because it is the report for the same location.

Loc | Improvement
XXX | Lowered COS
XXX | Brought in new Salesperson
XXX | Fixed Faulty Equipment

In the Summary Roll Up Sheet I want:

where "Location" is in cell A8 and Improvements is in B8 and XXX and YYY identify 2 of the 20 locations. YYY would only have 2 improvements while XXX would have 3.

Loc | Improvement
XXX | Lowered COS
XXX | Brought in new Salesperson
XXX | Fixed Faulty Equipment
YYY | Brought a new salesperson from Los Angeles
YYY | Catered Lunches for top salespeople

I have looked around the forums and got something close but not exact. Thanks so much for the help if anyone has a solution.

Here is the sample. There would be information in the other summary sheet but the roll up is not a part of that so I just put it in there to show there was another sheet that is not related to the roll up.

Thanks so much for the help. There would be 20 of the colored tabs instead of 3 but I think the 3 showed the spirit of the problem.