I have this code that I use, that works for what I need. I can go into the code and change the number of days to search, ie 30, 60, 90, 180, etc. I would like to be able to have an InputBox pop up that would allow me to enter the number of days to search before hand. Thanks for your help. This forum is invaluable!

Sub Expirations()
With Sheets("Expirations")
    .Rows(4 & ":" & .Rows.Count).Delete
End With
Set ws1 = Worksheets("Expirations")
OpenRow = 4
For Each ws In ThisWorkbook.Worksheets
    If ws.Name <> "Expirations" Then
        For Each Cell In ws.Range("AJ12:AJ" & ws.Cells(Rows.Count, "AJ").End(xlUp).Row)
            If Cell.Value > Date And Cell.Value <= DateAdd("d", 30, Date) And Cell.Value <> Empty Then
            ws1.Range("A" & OpenRow & ":AX" & OpenRow).Value = _
            ws.Range("A" & Cell.Row & ":AX" & Cell.Row).Value
            OpenRow = OpenRow + 1
            End If
        Next
    End If
Next
End Sub
-George