You can use Microsoft query to extract from Excel files - just make
sure your queried file is in database format - all columns contain the
same data types, no completely empty columns or rows etc. Data -
Import External Data - New Database Query. Choose Excel Files* for the
Data Source and navigate to the workbook and sheet you want to query.

You may also want to use the Worksheet_FollowHyperlink event to either
trip/display the desired query or just filter the sheet being linked
to so the info you want is displayed.

Cliff Edwards