I'm looking for the way of ensuring that when filtering a spreadsheet which
is a concatenation of other spreadsheets (using simple 3D references) the
displayed filtered list is updated automatically when a source spreadsheet is
changed without having to unset and reset the target spreadsheet's filter.

Or,
Is there a better way of showing a subset concatenation of rows across a
number of 'same format' worksheets where all the candidate rows have the same
value in a certain column. And, when the data on the source worksheets
changes the target concatenation shows the correct latest subset.