macro to Create 3 tables from tables in the attached sheet

Hi Friends

I have the scenario that I have the main table coming from the SSIS package view and it is a table in excel.

I have the code to add total at the end of the table. My problem is how can I create three tables with same headers, when One of the Brand name is same, for eg - Table 1 - If brand = XYZ
Date Brand Type Sales
15/04/2015 XYZ ABCD 2

Table 2 - If Brand = ZFG
Date Brand Type Sales
16/04/2015 ZFG DCBA 5

Table 3 - If Brand
Date Brand Type Sales
17/04/2015 TYUI EAEEA 3
18/04/2015 TYUI EAEEA 4

Please help me to create this through VBA code and after this tables are created I will send it through an email using outlook.