Creating a subset of data, from a larger table based on value in column with array formula

Dear Forum,
I have a main table (tab 1) and want to produce a subset table, based on the values of one particular column. The subset should reside in tab 2, 3, 4 etc
I have attempted to write an array formula but it does not seem to work and I don't know why
I'd appreciate any help
I have attached the spreadsheet
Many thanks in advance
Alex

Check your formula, you have

SMALL(IF(Table1[Equip No.]=$B$1

It should be :

SMALL(IF(Table1[Equip No.]=$C$1

Thank you asumi