Is there any way of collating worksheets such that one sheet summaries all
the information in the other worksheets when the cells do not necessarily
coincide?



For example,



Sheet1 has

A B

1 Australia 3

2 Brazil 2

3 Total 5



Sheet2 has

A B

1 Australia 1

2 Bangladesh 1

3 Brazil 5

4 Thailand 7

5 Total 14



And I would like to produce a summary sheet that looks like this



Sheet3 has

A B

1 Australia 4

2 Bangladesh 1

3 Brazil 7

4 Thailand 7

5 Total 19





This would save me a lot of time. I can guarantee that there are no spelling
mistakes or formatting differences for any of my data. Thanks for your help



Cheers