Automate vlookup to create New worksheets based on selection criteria

Hi,

I want to automate the following process IN excel 2007:-

Worksheet 'Product' is the master list and Sheet 1 contains the list of numbers which needs to be matched with Column F in Product sheet .

Based on the matching values of column F in product worksheet and column A in Sheet1,I want to create separate worksheets for the rows from Product worksheet based on selected values of column AC.

For example,
All the matched column F rows having similar values in column AC should appear in one worksheet and likewise for every unique value of column AC for the matched rows,separate worksheets should be created.
The new worksheets should contain only column values,F,K and Y-AD from product worksheet for matched rows.

Hope I have been able to explain myself clearly.Any help in this reagrd would really be appreciated.

Thanks,
Kolokor