Using a date to create a list from from a sheet

Hi,
I'm not new to excel, but pulling my hair out with this issue. And I'm sure it's a easy thing, but just not figuring it out. I have searched/googled and I'm just not finding what I'm looking for. And this may not be the correct area for this, so admin please move if needed.

I have a sheet that uses 5 columns titled: Name, Job, Date last worked, Date needs to work, Notes.

I want to use this sheet to create a list (all 5 columns) on a separate sheet with those who have not worked in the last 30 days. So going off of the 3rd column for the data sheet.

However, there are times where I'll need to look at who has not worked in the last 7, 14, 21 days as well. So I was thinking that I could add that as a input to the function in a cell on the list sheet.

I hope that makes sense.

Thanks in advance for your help.

Man, you rock. Thanks alot. I need to jump into the VBA stuff. I think that's VBA anyway.

Ran into a little issue I hope you can clear up for me. The sheet with the data is named "Currency Tracker" and the cell to input the number of days is E1 on the list sheet (named "Currency List"). Also, on the data sheet, the data doesn't start until row 5 and there are some header type rows after that. These are merged cells spanning 5 to 6 columns that denote the specific job title. In all, there are 4 of these headers, not sure if they will be an issue or not but. I would upload the spread sheet, but I think after censored to protect PII and whatnot it wouldn't be much help.

And one more thing, is it possible to make the input cell to where I can input any number of days? I do appreciate the help and hope I'm not asking too much, if so just tell me.