Issue sorting filtered data sets on separate sheets.

Hello, I'm running into some issues trying to set up a few different filtered sheets, and sorting them.

To start, I have one page as a 'Full Project/Master List', currently ~200 entries. These are split up into a few different project types (Solar, Battery, Heating, Cooling, etc.). I was then creating a separate sheet for each project type, which pulls all the respective entries using Filter, so different coworkers can manage/view their relevant projects. This is working OK.

Where I'm running into issues is trying to sort/filter the data on each of these individual sheets. We may want to sort based on a few things (Customer Name, Priority, etc.), and would love to be able to swap back and forth. I added a filter drop-down at the top of each column, but I get the 'You can't change part of an array' warning when trying to sort any of the specific data sets on their individual sheets.

I'm assuming this is because it can't sort these entries on the 'Full Project List', but I'm not sure of the best solution. Will this work like this? or is there a better way to set all this up?

Thank you!