Can a macro be written so that with a button it will search all tabs for data
in a specified cell?

For example, find A2 searching all tabs.

Thanks.