How to link data from one table to another in separate worksheets.

Hi,

I tried consolidation but I can not get the following to work. Can somebody try this dummy application and if they figure out how to do the following below can give me a step by step guide so I can attempt myself to learn:

In the dummy application I have 2 worksheets. One known as "1st", the other "Cases". In the "1st" worksheet you can insert and delete records for the "Case" table at the bottom, what I want to do is insert a row into the Case Table in worksheet "1st" and enter in the data for that row. What should happen is that data should be automatically be updated in the table in the "Cases" worksheet. But I can't seem to get this to work. Also if I delete a row from the table in Worksheet "1st" it should automatically remove that record from the "Cases" worksheet table.

Please help.

Below is the spreadsheet: