Which feature is used to summarize data from multiple worksheets but does not require that the data be in the same location on every worksheet?

Data consolidation combines information from multiple worksheets and can match entries by their row or column labels, so the data does not have to be in the same locations on each sheet. A 3-D reference, by contrast, refers to the same cell or range across worksheets, so matching locations are required. The correct choice is data consolidation.

AI-written and checked against the verified answer.