Aggregate the content of several Notion Pages into a single page

Hi everyone, i’m struggling with an automation since few weeks so I hope you guys can help me.
Here’s what I wanna do:
I have made a database in Notion that is my social media planning : Each item of the database is social media post that is displayed in a calendar view.
The title of the item is the topic of the post. The content of the post is the wording of the post and a pic to illustrate it.
My aim is to generate weekly summary. To do that I have added a check box property in the database. i want the weekly summary to be a new item in another database in Notion (weekly summary db) that contains all the content of the post that I have checked (checkbox true).
How Can I grab the content of the checked item and aggregate this content in a new item (weekly summary)?
Many thanks for your help

Hi Zac, would you need a “duplicate” page in your weekly summary database, or would a relation to the original content suffice?

If a relation suffices, the implementation would be simpler. Else, you would get to list the page contents in Make, and then create a database item + append the page content into the new item