Array Return Multiple Values In One Cell

I am trying to return an array of values into 1 cell.

Basically, I have a gigantic list of item names, item numbers, and reuse codes.

I want to populate all the reuse codes by item number in a second sheet:

something like this:

Source sheet
Item item num Reuse code
Widget1 w001 298767
Widget2 w002 4894957
widget3 w003 28276
Widget1 w001 12345
Widget1 w001 678910

What I want this code/formula to do is consolidate the reuse codes based on the item number.

Aggregate Sheet
Item item num Reuse code
Widget1 w001 298767;12345;678910
Widget2 w002 4894957
widget3 w003 28276

I have this formula but it only gets the 1st Reuse code, I want it to get ALL reuse codes for that item.

{=INDEX('Reuse list '!$P$2:$P$24489,SMALL(IF('Reuse list '!$E$2:$E$24489='Status Sheet'!A11,ROW('Reuse list '!$E$2:$E$24489)-ROW('Reuse list '!$E$2)+1),1))}