Return entire row when value is matched in another sheet
I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property).
What I would like is to have have any rows in the source sheet which match a specific property populate in full in the designated destination sheet I have made for this property.
The practical application is I have a giant mega list of every item that has gone to every property, but also have individual sheets for each property that only show the data for that property.
Is this a VLOOKUP function?
Thank you in advance