Show All Project Tasks By Clicking Their Folder

I have created a folder for each area of my life. Each of my folders then has multiple projects in it. I would like to be able to click on the folder, and see all the tasks in the folder from all the different projects in one place.

For example, my "writing" folder, has multiple book projects in it that I am working on at once. I would like to be able to click on the writing folder, and see all the writing, revising, etc. tasks for all the books at one time. Otherwise I can't tell what the timelines of my projects are to create new tasks, without clicking back and forth. Every other task manager I've used functions this way so I'm finding it difficult to work around. Hopefully it's an easy fix. Thank you!