I have several spreadsheets in my workbook which have a column with the same
reference numbers.

It is frustating to filter each spreadsheet individually...

Is there a way to filter for a reference number (in all the spreadsheets
simultaneously) only by one action on the first spreadsheet?