macro that extracts specific data from multiple worksheets

[ruudbo]

I need help!

Newbie to vba

I have an excel file with 25 seperate worksheets with similar data, each with 7 colums that consist of 2000+ entries...I need a macro that will extract rows with a specific dates (date is in this form2011.04.27) so that I can see all the extracted data in one worksheet...


Any help is appreciated,

Peter

 

[ruudbo]

i can provide more details if needed...