link tables

I have searched and searched for this. I have 2 tables. Each is on a different sheet. I need to have the data inputed on the first table to automatically show up on the second table on the second sheet. There are a few rows to the first table and each has a row that it needs to go to on the second sheet. But the columns are not next to each other. The other problem is that when an item is entered, it needs to add that line as well. I can send spread sheet if necessary.

yes please upload a small sample file.

I am sorry, I am new to forum. How do I attach file I want to send to you.

Logistics Plus.xlsm

Here it is.

Hi
Whilst you have added a copy of your spreadsheet you have not shown us what you currently have and what the end product is that you need. Without that it is difficult to help you. Post a sample of what you have and then a copy of what you want to achieve. This will help us understand what you need and be able to help you better.
Tony

In the spread sheet, I need for the data entered in each row on sheet AMTS1 to populate the corresponding rows columns on sheet ATS 1. If something is removed from AMTS1 then it needs to reflect on ATS 1. Both need to auto add lines as well. I have put a button to delete rows but if it can delete them if something is removed from AMTS 1. Hope this explains what I need.

Did you ever get this figured out?