How to make excel automatically accommodate the new data in table

I have created a excel table linking to multiple sheets , entire data in is added row wise in the table sheet.
When i add new rows in these sheets, the new rows are being reflected in data table sheet but replacing the data below, i want excel to accommodate this rows without replacing the rows below.
Please help

pleasee help

As you are using the 2016 version of Excel you could:
1. Produce separate row wise tables for each matrix
2. Append the tables using the information given in the linked video starting at the 3:56 mark: https://www.youtube.com/watch?v=sb0hmwiFM-E&t=2s
A small sample of the table that is produced from the iPMO and TP+PLAUD sheets is shown on the Data Table sheet, columns J:Q using the following Power Query Advanced Editor code:

Please Login or Register  to view this content.

Let us know if you have any questions.

It would be easier to troubleshoot using a file rather than a screenshot, please utilize the instructions in the banner at the top of the page as you did to attach a file to post #1.

Although it is hard to see the screen shot, I feel that you could rectify the error by selecting the drop down arrow in the Name field > Unchecking "Select All" > Checking only those names that are associated with the tables on the Skills Matrix sheets.
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.