Macro to filter column and copy rows to new sheet with loop for all unique values in colum

Hello all. I'm new to macros and VBA but fairly experienced in Excel. I am trying to automate a repetitive process at work which can be quite time consuming and I am virtually lost as to where to start. We generate a report every week from Access which needs to be separated by the properties in the Property column and then sent to each individual property as a separate file. I would like a macro to either filter or lookup each unique property in the column and then create a new sheet named for that property and then copy the selected rows along with the header to the new sheet. This would then do a loop until all properties are copied.

We have a total of 47 properties but not all properties are on every report. If I could have a master workbook where we could paste the new report, run the macro, and do a Save As, it would be ideal.

Attached is a sample of the report. We are using 2010 at work but this sample is in 2013.

Any help provided would be greatly appreciated.

Thanks,

Jim

Here is a better sample of what I'm looking for. I've copied the rows for a few of the properties to their individual sheets.

Thank you Stnkynts!! That works perfect. Now I will have to try breakdown the code so I understand what each step does.