VBA program to limit date
 

Hi
I have a workbook with 20 worksheets. Each worksheet contain graph and
data which retrieved by query from a database. My question
How can I write a VBA macro program to limit certain period of time since
too much data collection now. Each worksheet has a column of "date" so I may
use this for macro program.
I can change query but too many query to change when requested.
A Excel form is better but don't know how?
Thanks
Daniel