I have 3 worksheets that I want to pull totals from. There is a header that I want to match and pull the respective totals.
i.e. row 5 has various titles - one being Brandywine. I want the Total (column A has the total label) for each column where Brandywine is shown in all 3 worksheets.
Any...