Good day! This is my first post, so bare with me as I try to explain this issue.

I am creating a live report for different managers that is linking relevant data from several different trackers.
So, for one worksheet, I'd only want to pull the data from certain columns (Y,Z, AA, AB, ect.) anything that relates to them, but not the entire row. I have a column that organizes the area each one manages (office, field, port, etc.).

If I use the office manager as an example, on one of the worksheets in his update, I want to link Columns Y,Z, AA-AG from another tracker if column AM in that tracker contains "office".

What I've done so far is filter the tracker to show "office" and link the cells individually, which works fine for those that exist. The real problem is that if another row is added on the tracker with "office", the new row won't appear on the managers update.

Is there a way to get the update to automatically add the required data anytime the tracker is updated with a new item? Also, is there an easier way to create a link to specific columns rather than linking each cell individually?

Thank you very much for your help!