Multiple Tab IF Statements

I'm having a hard time figuring out if this is an IF statement or if this would be a Macro. Here's what I'm trying to do:

I have multiple tabs with the same rows A-E. The rows are as follows: Date, Broker/Prospect, Property, Action, Status.

I have a master tracking sheet where all of the data will be entered. The 'Property' row refers to the address of the property and the different tabs are the different property address.

I want to have the input on the master sheet automatically fill in the same information on the correlating tabs, depending on the address that is entered in the 'property' row on the master sheet.

IF(Master_Tracking (sheet1), Row C = property address, then the data in the entire column on the master sheet will automatically fill in the entire column on the seperate tabs, which correlate to their particular address.

Hope this makes sense. It's been a long time since I've use VBA and forget how to code.