You could search the input tab list using code similar to:

Sub FindAcrossMultipleSheets()
Dim findStr As String
Dim wkSht As Worksheet
Dim found As Range
Dim rng as Range, cell as Range

With worksheets("Inputs")
set rng = .Range(.cells(2,1),.cells(rows.count,1).End(xlup))
End With
for each cell in rng
findStr = cell.Value
For Each wkSht In Sheets
if wkSht.Name < "Inputs" then
With wkSht

Set found = .Cells.Find(What:=findStr, LookIn:=xlValues, _
Lookat:=xlWhole, MatchCase:=False)


If Not found Is Nothing Then
' write name of machine and date to start
cell.Cells(cell.row,"G").Value = wksht.name
cell.Cells(cell.row,"H").Value = found.Cells(found.row,"C").Value
End If
End With
Next wkSht
Next cell

End Sub


Adjust to fit your actual situation. Code is untested and may contain
typos.


--
Regards,
Tom Ogilvy



"will" wrote in message
...
Hi,

I am trying to create a workbook for scheduling different jobs on our 10
different machines. I have a different worksheet for each machine, with a
separate "input" tab for the jobs to initially be entered on.

The problem I have is in highlighting a job if it has not been scheduled.
Is
there any way that anyone knows that I can highlight a job, or have a
result
come up, on the Input tab, if that job does not appear in one of the
machine
worksheets?

For info there are about 50 different jobs each week, so over a month one
will be scheduling 200+ jobs.

Thanks for any help.

Will