If Then Formula

See attached.

I create a sheet for the first one, VEAM

Formula in A3:

=IF(ROWS($B$1:$B1)>COUNTIF(Sheet1!$C$2:$C$43,$B$1),"",INDEX(Sheet1!$B$2:$B$43,SMALL(IF(Sheet1!$C$2:$C$43=$B$1,ROW(Sheet1!$B$2:$B$43)-6-ROW(Sheet1!$B$2)+1),ROWS($B$1:$B1))))

Formula in B3:

=IF(ROWS($B$1:$B1)>COUNTIF(Sheet1!$C$2:$C$43,$B$1),"",INDEX(Sheet1!$B$2:$B$43,SMALL(IF(Sheet1!$C$2:$C$43=$B$1,ROW(Sheet1!$B$2:$B$43)-3-ROW(Sheet1!$B$2)+1),ROWS($B$1:$B1))))

Both formulas are confirmed with CTRL+SHIFT+ENTER not just ENTER.

Then copy them down as far as you want

You can then make copies of this sheet and just change the reference in B1 to the appropriate Center.

I changed the Second center in the main sheet to VEAM for test... you can change it back if it was real.

Btw: What happened to your other username?