I am looking for help regarding a tool I’m creating in Microsoft Excel.

Context: I have a list of projects in one sheet, assigned to various people.

The goal is to have a macro that will look through the entire list, based on a given name, then return a list of information about each project they are running.

To give a visual:

And I need to create a solution that will return separate batches of information about each project the selected person is doing:

EDIT: To clarify further, the goal is a solution that, when I input a specific Assignee name in a cell, the system will pull all of their projects from the main chart, and return a list of charts, each with the project information filled in.
As an example, if I write “John” in the cell in question, excel will create two charts, each with information about the project from the respective row (Market, Deadline, Project Name, etc.).

Can you help me find the most optimal solution for this?

Thank you in advance.

Regards,
Simon

I have considered making separate macros for pulling data for each of the projects manually, by using Index, Match functions, but I feel that is a rather crude option.