Paste-link new table row from one sheet into the next available row in master sheet?

Hello everyone! I have been tasked with creating a new workbook for our Compliance Department. Here's the setup of the workbook:

The workbook contains one master sheet, and then several data sheets where data will be entered for each Compliance area.


I want the workbook to function like this:

Someone from a Compliance area opens their respective data sheet to enter new data. This data will be placed into a table (all sheets, including the master sheet, have the same columns for consistency). That employee uses the tab key to create a new row on the data to enter this new information. I want this new row to automatically be paste-linked into the summary sheet in the next available row so that the master sheet will pull all data from this data sheet and add it to the next row down. Since all columns will reflect the same information on both the master sheet and all data sheets, it should be a one-to-one copy and paste-link. The only issue is that I'm not sure how to make it figure out what the next available row is in the master sheet.

Also, if someone deletes that row later, I would like the master sheet to also delete that corresponding row and adjust the rows accordingly.

Can someone help? It would be greatly appreciated! I'm on a bit of a tight deadline for this!

I have done something very similar to this before, except in that instance, I was copying a specific row from a new sheet into the master sheet, not a new row. So I'm pretty sure the structure would look something like this:

Please Login or Register  to view this content.

I mainly just need help in figuring out the line of code to select the new row (specific cell range within that row) that the person creates to enter the new data. I'm pretty sure I know from that point forward how to get that row copied and paste-linked into the master sheet.

Okay, well anyway, some things have changed with this.

Now that I know that I can't paste link from a table, I have converted all sheets to ranges. Now I just need the code to check for additional rows of data and paste link them into the next available row of the master sheet, and do the opposite when a row of data is deleted.