select all worksheets
save as html
use search and repace to remove noise
copy /b *.htm merged.html

open in excel as html
copy and paste in notepab
search and replace blank rows
copy and paste as text in excel

copy and paste into msword as txt document
remove blank lines ^p^p with ^p
save as txt document
open in excel as tab delimited

select all from 1st heading down
select filter
this will make filter word across blank lines