Is it possible to write a macro or code so that value placed in a cell could
be found over all tabs?

For example, if I place a value in cell D5, could I have the code behind a
button that would searche for whatever value is in D5 over all tabs?

Thanks.