Run different filters on data and output each to a seperate workbook

I'm not by any means proficient with excel or VBA for that matter but I kind of poke and prod my way through things.

I have a very large set of data I'm working with. Every morning I have to pull specific reports for our various vendors from this data. I am familiar with Advanced Filtering and can manage to filter out the results that I do need but then I have to cut and paste the data manually.

I have made several workbooks containing just my criteria, I then used the Excel macro recorder to come up with this bit of code:

Please Login or Register  to view this content.

As I said I have several sets of criteria that I run against the data and I would like it to spit out to a new workbook (possibly with the day's date as the filename) each time I run it against the filter.

Thoughts?

Thanks in advance