One option might be to use Access (shudder, I know) to create a linked table that only links to the data you want and then export that back to Excel to a new file.