Consolidate multiple tabs with different formats into summary page

[Nicole87]

Hi,

I need to consolidate multiple tabs into a summary tab however they are set up differently but they all have the same account heading & country type, can anyone help with a formula or macro?

Thanks!

Example of tab 1

GBP USD CAD EUR AUD Resource Account 1 20.00 50.00 80.00 10.00 3.00 Account 2 40.00 100.00 160.00 20.00 6.00 Account 3 30.00 90.00 150.00 10.00 - 4.00 Account 4 170.00 200.00 230.00 160.00 153.00 <colgroup><col><col span="5"></colgroup><tbody> </tbody> Example tab 2 GBP CAD AUD Resource Account 1 20.00 80.00 3.00 Account 2 40.00 160.00 6.00 Account 3 30.00 150.00 - 4.00 Account 4 170.00 230.00 153.00 <colgroup><col><col span="3"></colgroup><tbody> </tbody> <colgroup><col><col span="5"></colgroup><tbody> </tbody> <colgroup><col><col><col><col><col span="2"><col></colgroup><tbody> </tbody>

<colgroup><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

GBP USD CAD EUR AUD Resource Account 1 20.00 50.00 80.00 10.00 3.00 Account 2 40.00 100.00 160.00 20.00 6.00 Account 3 30.00 90.00 150.00 10.00 - 4.00 Account 4 170.00 200.00 230.00 160.00 153.00 <colgroup><col><col span="5"></colgroup><tbody> </tbody>

<colgroup><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>