Not sure that this is possible by simply recording a macro. Is there a way
to code this by visual basic?

I have a spreadsheet that has a request date column...I am looking to create
a macro that creates a tab for each year, and then takes the information in
the spreadsheet and breaks it out by tab (e.g taking a workbook with one tab
for years 2003-2008, and making a workbook with six tabs showing information
by year)