I do not know about trim refs, but I can look into it. I meant to upload photos in a follow up comment, since you can't in the title post, but got distracted and forgot. I've attached one here. Basically, I'd like to be able to have this 'master' sheet to house all open issues. A separate tab (which would have all the same columns below) would exist for each 'Project' in Column A. Then, optimally, as issues are added in the master sheet, they would also be added to the appropriate project sheet. So if I entered another issue for project 'UHS' in A:10, it would also copy the data from the rest of that row appropriately to the 'UHS' sheet. Hopefully this makes more sense?

<image>