What are the three ways you can consolidate data across worksheets? When would you use each of the three different ways?

What will be an ideal response?

Consolidating by position is used when you have data in similar layouts on multiple worksheets. The consolidated data will be in the same layout as the source data. Consolidating by category finds categories of data and will group by those categories. The consolidated data will not necessarily be in the same layout as the source data. Consolidating with links will consolidate by position and will show the details behind the consolidated cells. The links will be in rows that are hidden and can be expanded or collapsed as needed.