Autopopulating table from previous sheet

Hi I am trying to create a table based on data from another table.

The first table contains two sets of data which i would like to seperate into two different tables automatically.

Im quite new to excel, so any pointers would be greatly appreciated.

Many Thanks
Kitty