Master sheet to another sheet automatically

human beings can understand that "aaron rogers all-stars" same as "a.r.all stars"
but excel will find them as separate strings
even in the case excel will find that
akron beaver(s) different form akron beaver chasers
even sometimes excel is case sensitive also

It is always better to give sheet names as the team name fully if possible or otherwise partof it

for example "aaron...." -sheet name can be called "all-stars"(you cannot miss minus sign)
because "all-stars" is part of team name, provided there are no all stars in another team name, I would always prefer the first preference complete team names

how are the names of sheets to be changed. Is it easy in your file. if difficult due to some reason
post back it can be seen whether some alternate method can be used

if possible change the names of sheets and send back the file better with a different name

when you send for solution preferably remove the autofilter.