Say someone had been tasked with compiling a load of information into a document and that they had, possibly wrongly, stuck it all into a big excel spreadsheet because they wanted to get out to watch the 5pm game. Now, say this person realised they need a search function on it but thinks that instructing people to ctrl+f doesn't look as good as they'd like. Well...is there a way of putting a search box into excel that will search all worksheets in that document?

I'm asking for a friend.