Update Worksheet to show only new/updated items from another worksheet?

[Iceshade]

Hi Everyone,

I have a function I am trying to build out and could use some guidance/coaching please.

I have a worksheet in a workbook that contains a table which is refreshed from a SharePoint list. What I want to do is, whenever this worksheet/table is refreshed it copies across only what is new/updated to the other worksheet.

I can get it to refresh, but don't know how to get only the new information to transfer across.

Apologies I am self/google-taught on VBA so very novice at this point - Any guidance will be greatly appreciated.

Thanks everyone