Re: Staffing profile name to be matched with project name once the project name changes..
You could create a report that runs on a set schedule. The report would execute the SQL to update the tables that Utkarsh identified. It would not be instant, but if you needed it updated quickly, you could just start the report.
-- Remember to give Kudos to answers! (click the KUDOS star)