I have a named range, 'student_subs', and wish to query this from another
sheet based on the value in a cell e.g 'Maths' and drop the data into a new
series of rows.

I have a query running already for other data but need to configure this
with MS Query by setting up an ODBC data source to the same sheet. This is
too complex for non-technical users of the workbook and hence I'm looking for
an alternate approach.

All ideas welcomed.