Info within cells or new sheet?

I am trying to figure out the best option for data within a cell. So the company I work for has about 200 properties in an excel spreadsheet. Some are single family up to multi apt complexes. With any property having more than unit for rent, we would like to be able to see a break down by address. I created a tab, and linked the tab to the address on the main tab. But now that new tab is over 400 lines long and it makes it hard to find certain data.

Is it possible to make the link take me to the corresponding cells in the new tab? Or can I make something on the main sheet, pop up with a breakdown per unit?

Thanks