duplicating rows every time the summary sheet is activated

I have not looked at the file or the code but what you need is to add an extra column. Now when the code is run you set the value for the row copied in that column to TRUE
And in the code checking you only check is the value in that column is empty (or FALSE) the only those will be copied.
I hope my explanation makes sense to you

I have looked at the file and I doubt it very much that it does anything at all.
You're working with actual Tables which make things easier but you also address these incorrectly.
You did not design this yourself so whoever helped you should be able to solve it for you.
When you address a Listobject (Table) the appraoch is entirely different

I corrected all the dimensioning and things but there are still errors in the code with Sheet loop
The first statement is incorrect but I do not have the time now.
Like I mentioned before this code never worked so what you are asking was incorrectly stated.
You say you get duplicated values, true, but you never got anything since the code did not work in any way possible.
You could be honest in stating that you received this file with code and do not know how to make it work.
Or you copied something forthe forum but delivered a non-working version .

Here is the file back without the dimensioning errors but still not working

You could at least take the time to answer, but...
Here's a possible solution

No problem, but it does help to be honest then the issues can be approached in another fashion.
BTW, and VERY important ALWAYS mention the Excel version (and OS if it is not Windows) you are working with.
I know from experience that Excel Apps I have developed do not work on a MAC, basic VBA might work the same so I home that my modifications will run on a MAC too.

What it basically does now is copy the new rows from the Master sheet PROJECT_LOG table to the Summary Sheet PROJECT_SUMMARY table and places a TRUE when completed in the last column of the PROJECT_LOG.

If you want to test it, just CLEAR a cell with the value TRUE and activate the Summary, this row will be added there.

No need to go through each worksheet since all the data is in the Master anyway.

Hope my explanation makes sense, and domn't make life difficult for yourself, just say what the issue is and what you have done, all the guys here try their best, we do this to help out and with every questions or post we learn too