Try this

Sub cellvalues()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Select
MsgBox ("Cell D5 in " & ws.Name & " value is " _
& ActiveSheet.Cells(5, 4).Value)
Next ws
End Sub

Is that any good?

Mike

"Gary" wrote:

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.