Reconfiguring variable assignments

Greetings,

6 months ago someone here helped me build a macro to reformat a report. I own a property management company and I use this report to list my current vacancies. The way it is generated through my management software is very difficult to read and is poorly designed. After installing an update to the software it changed the look and cell placement of the report and so my macro will not work . I have tried changing the cell assignments for the variables but some of the coding was a little over my head. I have attached a worksheet with the raw data and an projected output (or how I would like for it to look). The old macro is still in there and I think it can just be modified to fit this new report. Any help or advice would be greatly appreciated! Thank you!

-J