Seeking help filtering data across worksheets

Hi,

I tried searching the forum, but I'm not entirely sure what keywords to search for this problem. So I hope you'll forgive me throwing this out there.

I'm trying to create a workbook for our project team that will use a master worksheet listing all project info (dozens of columns of data for hundreds of projects), and then create an individual worksheet for each project manager to utilise (it will be stored on a shared drive). The master list will change over time, as new projects are added, old projects are closed out, and project information may be edited as needed. Because of this, the master list gets sorted regularly.

The intent was to create a worksheet for each project manager's projects, only a few of the more pertinent columns from the master list, but then add a few new columns where the project manager can input other info/comments that aren't included on the master list. This creates a mixture of cells that are filtered from the master list and cells with new inputs within the same worksheet. And anytime the master list gets updated/sorted, it jumbles up the rows.

I'm just trying to figure out if there's a way to synch the new inputs on the project manager worksheets so that whenever the master list updates/sorts, the new cells stay aligned with the sorted filtered data.

I'd appreciate any advice. I've tried using simple FILTER or LOOKUP or IF functions. I've also tried messing around with some tables and relationships. But I'm not having any luck.

Thanks.

Please attach a sample workbook.