Aggregate Multiple Dataheets into One Datasheet that Will Update Automatically

I have multiple datasheets with multiple records in each datasheet. Each record has a unique ID. Currently when a new record is added to a datasheet, it is automatically copied into the aggregated datasheet. I want specific fields for each record copied into the aggregated datasheet to automatically update when updates are made in the source datasheets. Is this possible and can you suggest how to do it? I thought of copying the row automatically and then using an index match function, but because multiple sheets are being aggregated the formula for the index match will have to be manually changed. Any ideas how to get around this

Answers