Complete data linked from 1 sheet to another w/in a date range

I have a large amount of data that was entered into one sheet that may not be sorted in any particular order of dates. I want to take this data with out modifying it and place it into another sheet.

The data is on the tool replacement data sheet and I would like to pool all the data that conforms to a date range of say June 2010 and link it to the June 2010 sheet. I have provided July 2010 sheet as an example. I would like to automate this as much as possible since this is a monthly report that I have to create.

Thanks
Chris

HI cwichlaz

find the formula in the attatched file

Thank you for the help Mr Azam That will work. I just wish I new as much about excell as you guys.
Thank you again
Chris

it is pleasant that it works for you.

i also have wish to know excell as much as the experts of this forum.

If your problem is solved mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it