Unique Strings, Sorting Macros, Creating Master List

[edscollects]

I have this workbook that does a number of different items. One the input page I input strings from external sources. I then run a unique strings macro which list each unique string with the corresponding years from row 1 that the string was in for each row. On this sheet sometimes there will be a string change but it is not an actual change. All these are listed on the name change tab of the workbook. Right now if I run the Summarisecodes_withcolours macro it lists each change whenever there is a name change, regardless to whether it is on the name change tab. Is there a way it can just ignore those changes that appear on the name change tab? Second, I would like to combine and sort all the output from the Summarisecodes_withcolours macro on a separate sheet placing all the like outputs together from any of the columns so that for instance all the 01ACC's are together, etc., in addition included with the school shown in column B on the input sheet. So it would look something like this.
01ACC
Clemson 1982-2023. 1981-1981
North Carolina 1982-2023, 1981-81 and so on
01B10C
Illinois 1982-2023, 1981-81 and so on

Any help is greatly appreciated.


NCAA 4-14-23.xlsm