Rather than using Excel and wasting a ton of time. Use Xero. Use the Xero tracking to track the income and expense of each property. Then each month do a report on each property individually, based on tracking. Job done.
I do this with a client who has 100+ properties and we can give him a P&L for each property, every month.