Create matrix from larger table

In the attached find these dynamic named range formulas (DNRs) in Name Manager.
There is a copy for quick examination listed in O:P of 'ScoreSheet'

Berger_ACTIVE	=INDEX(Berger_Table!$C:$C,COUNTA(Names)*2):INDEX(Berger_Table!$3:$3,,MATCH(1E+306,Berger_Table!$3:$3,1))
Names	=ScoreSheet!$B$2:INDEX(ScoreSheet!$B:$B,MATCH("zzzzz",ScoreSheet!$B:$B,1))

Berger_ACTIVE
Defines the range that is visible in 'Berger_Table'. Try making the visible range larger/smaller. The DNR resizes to fit the data.

Names
Defines the range of names in 'ScoreSheet' column B.

In C2 is a helper cell. It just defines the number of columns (Venues?) by dividing number of Names by 2.

Formula:

=COUNTA(Names)/2

The formula for Player1/2 pairings is in H2 filled down and across.

Formula:

=IF(ROWS($A$2:$A2)>$C$2*$D$2,"",INDEX(Berger_ACTIVE,(CEILING(ROWS($A$2:$A2)/$C$2,1)-1)*2+1+(COLUMNS($H$1:H$1)-1),

MOD(ROWS($A$2:$A2)-1,$C$2)+1))