Update: Project list by department. Pulling the list from another tab.

I have this simple spreadsheet I am using to track capital projects with the city I work for. on the first tab "Raw Data." I have all the info about all the projects. The second tab "Report" is a simple report using vlookups to return specific information about each project. The third tab "Dept. Summary" is giving me some grief.

I want to list all the projects and their funding sources by each department here. I want a formula to look at the Raw Data tab and find all the projects that the specific department has, and list them in the highlighted area. Since the Raw Data tab is constantly being added to, this formula would need to always be looking for new projects.

Is something like this even possible? If there are questions, let me know. Thanks!