Filter 3 worksheets to look for a specific date

[NewbieOfMacros]

Hello,

I need to create a code that will look at 3 worksheets, named "north, south, east" and within those sheets filter for a specific time frame in a column with a header named "scheduled start date" (like july 14 2011 - july 14 2012)

thanks!