Pull Data from one table to another

Good afternoon.

I have tried searching for the answer before i post, and have tried various things to do this in my own spreadsheet, but it seems i am missing something. So i created a simple representation of the spreadsheet to facilitate what i need.

The main table is the user inputed information. It is dynamic in that the user will be adding more rows as time goes on. The other tables are going to be generated on their own via equations (i am not interested in using macros) and pulling the information from the first table. Each table (not including the first) pulls the information from the first tabel dependant an one item. It will hold all the original inputs and allow for more to be added later.

Again, this is in the example with how the information would look, equations withstanding.

If someone could help me out, it would be greatly appreciated.