create wbook from TEMPLATE wbook

[sal21]

Assuming i have template.xls in c:\test\

http://www5.rapidupload.com/d.php?file=dl&filepath=2650

I open wbook MASTER_INPS.xls.
Into this wbook MASTER_INPS.xls is present a sheet TABELLA.
Into column A of TABELLA are present many value.

Is possible to filtre based TABELLA column A, the value into column A of A.T. CAMPANIA, after the copy entire range filtred from A.T. CAMPANIA sheet, save in c:\test\ the realted TEMPLATE renemed with: name=name of criteria filtred for example: 4500_&date_of_system similar 4500_14112005.xls

Cicling this creation of new wbook for each value into TABELLA

example:

the first value into tabella is 4500, filtre all data into a.t.campnia with index in A 4500, copy all range selected and put into wbook template from A3, save the template wbook c:\test\4500_14112005.xls...

the second value into tabella is 4501, filtre all data into a.t.campnia with index in A 4501, copy all range selected and put into wbook template from A3, save the template wbook c:\test\4501_14112005.xls
ecc...