Pivot Table/Filter/Sort/Copy Data to new Tab

[enochstrok]

Hi, i saw this advertised by an old instructor for an excel class, his youtube channel is "excelisfun" and he does a great job. I was trying to find the right video to answer my question but didn't know what to look for but have tried index and vlookup with no avail yet so i thought i might give it a shot to ask here to be pointed to the right direction.

My situation:
I download construction bid listings from a public online website to tab 1 "input" using "external data from web" from 199 different links/companies. Each one has from 0-20 bids that are all hyperlinked with format (date @ time) (bid info) and i want to filter everything by dates in the future. There are about 450 listed projects at one time but 50 of them are actually in the future. How do i filter everything without destroying the external data from web format and still keep the links to the projects?

here is an example of the website source: Andersen Construction Co. - Seattle - Projects Bidding

This is my current proceedure:
Tab 1 "Import": Import data externally
Tab 2 "Export": Copy & Paste and Text to column to get rid of @ symbol and timestamp but leave date only in the date format
Tab 3 "Report 1": Pivot Table and filter based on dates in the future
Tab 4 "Report 2": This is what i would like to have happen, automatically copy only the info that is not blank and filter based on dates in the future (we rarely bid on past projects). I manually copied one over so that i could show what it would look like. Any solution would be great, even if i use 1 or 2 tabs.

Below is the link on googledrive, feel free to download it. It should still be in excel 2007 format and not in google docs format.
https://docs.google.com/open?id=0BwbiLBpGGz6YamJseVJ6Wlg3Tnc

Here are the snapshots below to get a quick idea:

Tab 1 "Import"

Tab 2 "Export"

Tab 3 "Report 1"

Tab 4 "Report 2"