Pulling to a new sheet based on Criteria

I have attached a file which I need to make a report that pulls all columns to a new sheet if the Date Assigned was in the last six months or if (C2 > EDate(today(),-6)).

This is an ever changing file with data constantly added and deleted, so the formula used needs to be flexible.

Can anyone help me create a sheet that will do this. I am quite familiar with formulas (Not familiar with sumproduct, but can learn), but am not familiar with Macro language.

Duplicate post here: Help With Pulling specific data to a new worksheet