I have header and detail type information, and would like to use the filter
function on the header spreadsheet then have the spreadsheet link to the
detail spreadsheet and just display the rows associated with the data in the
filter from the header.

Worst case I can combine the two spreadsheets into one via vlookup and just
repeat the header information for every detail line but would like to keep
the smaller file size associated with holding the data once.