Sorting data

Hello again. I thought i'd try and be a bit clearer so i'm uploading a sheet to explain.

The spreadsheet can be downloaded here: https://drive.google.com/open?id=0B2...011RzlCdWZIclk

As you can see the first tab, 'Starting Universe', has all my raw data. Stock ticker, name, sector, industry and country.

Note this data is not fixed. The stocks can change so there may be different industries (though there is a max of 11). There could also be different countries.

The second tab, 'Industry Template', the template file of the data I want to populate.

I am planning on having 11 tabs, one for each industry. On each tab I want a new table to be created for each country, as you can see in the template file. COUNTRY 1, table, COUNTRY 2, table, etc, etc.

I want to create a macro that basically counts how many stocks for each industry in each country then populates the tables in each of the industry tabs with the those stocks.

I am struggling to come up with an idea how to do this and would appreciate any input.