Pls help with valid code. Thanks

Hello,

I have a xl sheet which contains junk values and required values in mixed format

I need to separate the required values alone and put them in separate sheet under a table format

consider,

Sheet 1 contains junk values like, (everything in cell like (1,1) (2,1) (3,1)

row 1- NOWBS BJSDD ADSD\QA\QAAAA\SDSDD\&&asassss\50541 proj name
row 2 - FGFGgJLKJJKJH\Qa\QAAA\GSfgsgsgsgsg\&&zzzzzzz\64482 proj name

I have to separate the 5 digits project number alone ie(64482 and 50541) and place it separately in another sheet in a table format

Can anyone pls come back with a code and steps

Thans in advance