Sumif across multiple sheets, like an index,match

[psrs0810]

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 help is greatly appreciated.
Thanks

 

[Special-K99]

If the layout of the sheets are identical you may be able to use 3D Reference / 3d Sum

Google 3D sum Excel see if its any use