Which function allows you to sum data from multiple worksheets while maintaining links to the source data?

The function that allows you to sum data from multiple worksheets while maintaining links to the source data is called Consolidate. This feature is specifically designed for aggregating data from various sources within a workbook, such as multiple worksheets, into a single summary sheet.

When using the Consolidate function, you can choose to consolidate data using different functions such as Sum, Average, or Count, among others. Importantly, it gives you the option to create links to the original data. This means that if the source data changes, the consolidated data will automatically update, reflecting those changes without needing to manually refresh or adjust the individual cells.

This functionality is particularly useful in scenarios where large datasets are spread across different sheets and you need to compile summaries or totals without losing connection to the original data, ensuring accuracy and efficiency in data management.