u/Will_532

Not sure I explained it that well in the title but here's a better summary. Creating a sheet that takes in raw roster data of all NFL rosters for work and attempting to sort a specific section of the sheet alphabetically to help with checking other elements we are creating and using the sheet as a tool for confirmation.

Here is a link to the sheet: https://docs.google.com/spreadsheets/d/1_88X398HJvUzztWr7XQxeDOfShscqx00zkZKXyYlClI/edit?usp=sharing

What I'm looking for is in the "Copy of PLAYER ELEMENTS" tab...I've written a formula in cell B2 that sorts exactly what I'm looking for in terms of listing rosters & all info provided from the ROSTER tab correctly in alphabetical order in in the exact cells I want them to be in for columns B-F. The issue is columns G-K all need to be manual entries. So, what commonly occurs is the roster tab is set initially, which allows me to go through and enter all the manual data in columns G-H with no issues, but eventually, before I'm finished using the sheet, rosters will change which requires a manual input of new data in the ROSTER tab. When this happens it auto updates the alphabetical order of columns B-F on the Copy of PLAYER ELEMENTS tab, but it will not auto update the manually entered data in columns G-K. Is there a way to have columns G-K also update along with columns B-F when a new player is added to the roster tab and the alphabetical order changes.

This is a task that I use every week, creating a copy of the spreadsheet and applying to a different matchup. I'm decent with google sheets having built out the rest of this on my own, but am truly stumped by this issue. Once a sheet is fully up and running up to 15 people could be looking and editing in it at one time. I'm working on it in Chrome and the vast majority of people viewing & working in it will also be using Chrome.

Hopefully this covers the necessary info, but I'll happily answer any other questions.

Thank you in advance for any help provided!