How to lookup multiple rows from a table

[trabical]

Hello. I am having a problem trying to figure out how to make a formula that will pull a record from sheet 'Current' to another sheet called 'Needs to be Done.' On sheet 'Needs to be Done' I want the expired records and records that are going to expire within the next 6 months to be displayed as a table. I've tried to piece together formulas from forums around the web but can't seem to figure out how to get it to work. Any help would be greatly appreciated. Thank you!

P.S. I am using Office 2010 on Win 7 PC.