Generate reports

[thunder_anger]

Hi all
i tried to do this myself but it was a dead end

i have a workbook with about 34 sheets and all things are ok with me
all sheets have the same table
A1 : m1 are the headers of the table
Serial-Product code - unit price - Quantity - registration date "E column" -etc....
serials are already different
sheet1 ends with 25000
sheet2 begins with 25001
and so on
what i want is that to generate a new sheet contains all rows that are in a specific date or a date range i enter in an inputbox
the thing that could kill me now is that whenever u try to this i fail because i have three rows in sheet 3 in the range from 2-jan-2009 to 15-may-2010 and the rest of the data are in sheets 4 and 5
any one can help me to do this
you will save me
new to Macros and VBA

 

[hossamazab]

me too thunder
i just wanted the same but in a word document
is that possible
i join your question