VBA, Find, Critera

Hi All,

I have a large data table, with KPI's from several site/countries. (Will be imported monthly).

I want to split it into smaller tables with a country on each workbook.

Instead of manually creating a new table and finding and referencing individual cells I would like to automate it.

I've been trying IF/AND's and VLOOKUP/INDEX/MATCH but i thinks its too complicated to work, and i think i need some VBA Script instead, but it been over 6 months since my training...

I would like to create a new table, by looking for and finding data in the large table.

For example...

Look in Table1 A:A = "France" AND B:B = "Le Harve" AND C:C = "KPI-01" AND F:F = "KPI Score" if all conditions are met in that row to return Column A in that row.

The new table would continue to fill in this way with B returning Table1 B in that row, C returning Table1 C, D returning Table1 G, etc as needed in the new table.

Please help, i've been trying all day! I know that once the first bit works i'll be able to amend it accordingly for everything else.

Thank you.