To show resource requirement forecast of all projects, an Excel file with macros can do it better than Microsoft Project.