How to use Macro to generate different reports

Hello,

I come across a question recently. I am hoping someone could help me.
I work for a property management company with over thirty properties and our property manager records his work in a spreadsheet everyday.
Normally, he sets up a spreadsheet with the titles: date, property code, property name, time, and descriptions about what he has done. Considering that he works on multiple properties at the same time and record all his daily work on one spreadsheet, we would like to generate reports that could contain his past work under different properties' names.

For Example:

Date Property Code Property Name Time Description
1-Mar 0000001 Property 1 8:00 AM Repair the window
1-Mar 0000002 Property 2 9:00 AM Meeting with tenants
1-Mar 0000003 Property 3 10:50 AM Contact Vendor

I am thinking to convert this format into another one by using Macro in Excel, so that the project manager can get two different report but only enter information at one time. One report records his daily work on all properties, the other one is a summary of his work on one specific property .

The other report could extract information from his daily log automatically into a format like below:
Property Code 0000001
Property Name Property 1
Date Time Description
1-Mar 8:00 AM Repair the window
2-Mar 8:15 AM Call repair vendor
.
.
.

Is there anyone who could help me solve this problem by writing a simple in Excel Macro?

Thank you very much!!!