Dynamic summary page multiple tabs text not values

[Harriman2022]

Hi,

To give a bit of background - I work for a property company which has multiple different entities. Each entity has a tab on a spreadsheet which has certain bits of information about each property it owns. As we acquire new properties, these are added to their respective entity tab and the information is entered.

I need to create a new summary tab which pulls the information (text and numbers) from each of these entity tabs - they all have the same column headers - the new summary tab will also have these same column headers. The information on the new tab does not need to be editable, but it does need to auto populate when a new property row is added to a tab.

The easier option may be to have them all on one page and just have filters, but I would rather it was seperated so it was easier to send individual pages to clients etc.

Can anyone help?

Thanks,
Alex

 

[Harriman2022]

Example image of one of the entity tabs below.