Create Multiple Sheets from master sheet with VBA

[grungernelly]

Hi I'm sure this can be done but I cannot for the life of me work it out.

In a nutshell I want to copy (create) multiple workbooks and name them based on the list

of filenames in Sheet1.

I have a sheet with a list of file names in column A e.g:-

A - 2011.xls
B - 2011.xls
C - 2011.xls


However, the basis of these newly 'spawned' workbooks will be all of the other

worksheets (let's say Sheet2 and Sheet3) in the master/creator workbook.

That is the first task. The second task is inserting the values of Column B (in Sheet 1

in the master sheet) into a specified cell in the newly spawned workbooks for example

these values
A
B
C

into Sheet2!A1.

The third and final task is to print Sheet2 of each new workbook to the default printer.

Can this be done? If only part of it can, this would be a great help.

Thanks in advance for your help.

Neil