What do you mean by "combines the related fields"?

If you mean "sums" then you can use

=SUM(Sheet1:Sheet5!A1)


where Sheet1 is the left-most sheet and Sheet5 is the right-most sheet
that you want to sum.

In article ,
"Wordgeek" wrote:

I have multiple worksheets with at least one common field. I need to create
an additional worksheet that combines the related fields based on the field
that is common to all. Which function does this?