You may want to look at how Ron de Bruin and Debra Dalgleish approached this
kind of thing:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Or:

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

=======
Remember that worksheet names can't have slashes in them. You'll have to format
them differently (maybe with dashes???)

Funkyfido wrote:

I have a spreadsheet with a huge amount of data on one worksheet. I am
looking to put all data on a new worksheet whenever the data changes. Any
idea how I could do this automatically? I would like to rename the worksheet
as well to the date.

Name Position Transaction Date
Jimmy Test anything 20/04/2009
Jimmy1 Test1 anything 20/04/2009
Jimmy2 Test2 anything 20/04/2009
Jimmy3 Test3 anything 20/04/2009
Jimmy4 Test4 anything 20/04/2009
May any Test 20/04/2009
Shirley new anything 21/04/2009
Shirley1 new1 anything 22/04/2009
Shirley2 new2 anything 23/04/2009
Shirley3 new3 anything 24/04/2009
Shirley4 new4 anything 25/04/2009

Thanks

--

Dave Peterson