one of the options is to use a realy looooooong if formula.

=if(a1="qb",a1,if(a1="second postion","second postion",if(a1="3rd position", 3rd position, if(...

another option is to do this semi-manually:
1)highlight the 1st row (where all the row titles are"
2)press the "filter" button. You can find it on the tool bar under the"sort & filter" button.
3) now you can press on the little arrow in the 1st line in the row of positions and mark only the position you are intrested in (let's say "qb")
4)highlight the whole spreadsheet and "copy"
5) go to a different spreadsheet (named "QB") and just paste
6)repeat for every position and every time the "Master Spreadsheet" is updated

Cheer up it's not as much work as it sounds