Macro to filter every tab from a user entered date range

Hello -

I am very fresh to macros. I want to have a user specify a beginning date and an end date on the 1st sheet, hit a button, and then have the macro filter every tab (excluding the 1st three tabs) from row 4 down to show only the rows that have the specified date range. I'd also like an undo of sorts that will reset every tab back to it's original state. I will continually be adding new tabs into the document, so if possible, I'd like to avoid having to enter the tab name into the macro every time I have a new tab.

Any suggestions/help would be greatly appreciated!

Hello Penny,

How are the dates arranged on then worksheet?

Example A by Starting and Ending Dates only

Please Login or Register  to view this content.

Example B by Individual Dates

Please Login or Register  to view this content.

Sincerely,
Leith Ross

On the tabs that are being filtered, the data looks like this:
A
1 9/1/07
2 9/4/07
3 9/14/07
4 9/14/07
5 9/16/07
6 9/30/07
7 10/1/07
8 10/2/07

The information is like this on tabs 4 through 20.

I would want a user to be able to enter a date range such as 9/1/07 through 9/30/07 on the 1st tab (perhaps one cell with a start date and one cell with an end date); it would then filter to show only dates 9/1/07 through 9/30/07 on tabs 4 through 20, without having to use the autofilter on every tab.

I hope I'm making sense.