Search for a date or date range.

Thanks in advance for any help.

I am trying to create a macro which will allow me to search for a specific date (25/05/2011) or date range (any date with in **/05/2011 for example), I would like for this search to search all worksheets in my workbook. I have a "Search" worksheet already for the search results and will use a button to start the search. All the date's in the workbook use the dd/mm/yyyy format. When a match is found I would like the whole of the row that this date appears in to be copied and pasted to the Search worksheet.

Any advice/help would be much appreciated.