Combining kanban boards into joint list

Help
1

Hello,

I have a vault with the following structure:

vault
│   Master.md
│
└───Project A
│   │   Project A Kanban.md
│   │   ...
│
└───Project B
│   │   Project B Kanban.md
│   │   ...
│
└───Project C
│   │   Project C Kanban.md
│   │   ...
│   ...

I want the Master.md to have the following format:

# Todo
## Project A
{List of cards in the "Todo" section of the "Project A Kanban.md" board.
## Project B
{List of cards in the "Todo" section of the "Project B Kanban.md" board.
## Project C
{List of cards in the "Todo" section of the "Project C Kanban.md" board.

# Doing
## Project A
{List of cards in the "Doing" section of the "Project A Kanban.md" board.
## Project B
{List of cards in the "Doing" section of the "Project B Kanban.md" board.
## Project C
{List of cards in the "Doing" section of the "Project C Kanban.md" board.

I have tried doing this with dataview but up till now I’ve only succedded in pulling the filenames of all my kanbans.

Any ideas? Any suggestions?
Thanks in advance.

2

Please show your query as of now, and at what point you’re stuck.