Resource Management - what is the best way to determine which new project requests can be worked on versus which ones will have conflicts with resources on other projects?

We are trying to get a better view regarding how many planned hours each project will take and the remaining hours, what the roles on each project are and the # of hours each role has planned on the project. We have the following:

1. A resource management dashboard that has reports based on teams and their availability. These reports are built in the Portfolio Optimizer using filters. The URL is copied from the filter and a report is added to the dashboard by selecting "Add External Page" and pasting the URL
2. A report that shows the projects by priority (the report pulls this info from the Portfolio Optimizer) and also includes the total # of planned hours for the project as well as the number of remaining hours for that project.
3. A report that is grouped by projects and then by job role which also includes the # of hours each job role has assigned to them for every project.
4. A report grouped by Job Role and then by Project to show how many hours every job role has assigned to them and then how they are assigned across projects.

The goal is to be able to review new project requests, determine which job roles will be necessary to work on the project and then determine when the project can be started based on current capacity across those job roles. It feels very manual and labor intensive to gather that data from the reports and I am wondering if anyone has produced reporting that would help automate it?