i am looking to enter a search term, look in the entire workbook for the
term, then return the sheet name and row number of all found instances. wild
card searches would be a bonus if possible. tried a few things but nothing
works quite right.