macro required to filter data on several tabs and save to a file, then repeating action

[Stevengreen22]

Hi guys,

I would like to implement a macro on a very large spreadsheet tha tis generated each week.

What I'd like is to be able to filter Column 1, I woudl also like this to be the same across several tabs. So each tab would display only the data for 'Patch 1' for example.

Once this is displayed I'd then like to be able to save it as a seperate sheet plus the date. So the save name would be something like Patch 1 April 2012.

I'd then need to repeate this process with all other 'Patches'.

Could anyone lend a hand?

I know my way around java to an extent but vb is like a wild creature to me

Many thanks in advance.