Look at EasyFilter
http://www.rondebruin.nl/easyfilter.htm

You can filter on Month-Year, Days, Weeknumber, Weekday, Nth Weekday, Quarter
and copy to another sheet or workbook


--
Regards Ron de Bruin
http://www.rondebruin.nl



"urguy" wrote in message ...
I have a spreadsheet that we use to keep a record of requests for
information. I have a workbook listing all requests over the last three
years. We would like to create a new workbook for each year. Without
copying and pasting, how can I have the new information that is requested
automatically be entered into the workbook for that corresponding workbook.
Any suggestions would be appreciated and thank you in advance for your time.