Add report query options to a sheet

TCJ

Hello, I seem to always be looking for is to pull data or tasks from across our the project portfolio, and provide that data to specific functions, like our manufacturing team. Reports are great for this, but the functional group always wants to add their own columns to manage the work in their own area. There are usually ways to do this, but it would be so much easier if it were possible to have the query abilities of a report AND the ability to add custom sheet columns, all within the same sheet.