sorting data from different sheets into single sheet

[duucfho]

this is for a fantasy football sheet that i am creating. i have
multiple sheets, one for each player position (QB, WR, RB, TE). on
each sheet, i have columns for name, and projected points (as well as
other columns that aren't relevant). my goal is to create a new column
on a new sheet, that basically lists the best players available,
regardless of position. so basically, i need say the top 10 players,
ranked by their projected points, regardless of position. and i need
this list to be constantly updated, because players will be drafted,
and i will no longer want them listed in this "top 10 available" list.

i can create an automatically sorted and updated list for a single
position (basically pulling data from one sheet). but i can't figure
out how to pull data from multiple sheets to create a single output.
here is the **array** formula i used to do a single data set:

=IF(ISERROR(INDEX(QB!$A$1:$B$200,SMALL(IF(QB!$A$1:$A$200=$A$1,ROW(QB!$A
$1:$A$200)),ROW(3:3)),2)),"",INDEX(QB!$A$1:$B$200,SMALL(IF(QB!$A$1:$A
$200=$A$1,ROW(QB!$A$1:$A$200)),ROW(3:3)),2))

note: that formula is an array formula. it is pulling data from the
QB sheet. it is searching the QB array for players that do not have
their "Drafted" cell filled (undrafted).