collecting data from one sheet to another
 

is there a way to use a function or a macro that looks for or between certain
dates in a column and it the condition is met, then print the contents of
certain cells on another worksheet to be used in a Merge file?

EX:
A B C D E
10/1/2006 Keller John po box 3 austin, tx 80479
10/3/2006 Leroy Smith 122 way st Dallas, tx 80775
..
..
..
10/31/2006 stella youst 34 New Ln peru, mi 49874

Now if column A is between 10/2/2006 and 10/26/2006,
print its contents from row C, D E on another worksheet to merge into a word
document?