Reformatting or consolidating multiple worksheets for summary

[Melimob]

Hi All

I have a workbook where each tab represents a country. Within that, it shows the same functions and items per client.

I need to summarise the data across all sheets to extract key pieces of information without having to reformat the sheets. I inherited the workbook so don't want to re-invent the wheel.

The way it is formatted at the moment it's difficult to pivot on due to the way it has been structured. I have looked at Get & Transform tutorials but again, can't see how I can relate and condense all info the way I need it.

Here's an example of how it is set out -starting from column B. Column A I haven't included but there's a merged cell to catagorize the function. All the below items fall under a header called 'General Information':


[TABLE="width: 407"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]ITEM[/TD]
[TD]CLIENT A[/TD]
[TD]CLIENT B[/TD]
[/TR]
[TR]
[TD]Region[/TD]
[TD]APAC[/TD]
[TD]APAC[/TD]
[/TR]
[TR]
[TD]Phase[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Incumbent Partner[/TD]
[TD]Company A[/TD]
[TD]Company A[/TD]
[/TR]
[TR]
[TD]Partner Contact BM[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Contact E-Mail[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Client Contact[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Contact E-Mail[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account mgr[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Contact E-Mail[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Receiving Partner [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Partner BM[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD]Contact E-Mail[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Annual $ Spend[/TD]
[TD]$50,000[/TD]
[TD]$100,000[/TD]
[/TR]
[TR]
[TD]Annual Air Transactions[/TD]
[TD]500[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]Annual Hotel Transactions[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Annual Car Transactions[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Annual Rail Transactions[/TD]
[TD]9[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Total Transactions[/TD]
[TD]511[/TD]
[TD]911[/TD]
[/TR]
[TR]
[TD]Other Countries Serviced[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Target Transition Date[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]


I need to summarise by:
Region
Country
Client
then by item as needed

Any advice on structure or what method to consolidate will be greatly appreciated.

Many thanks