VBA Code for copying/pasting from Master-to-target files

[Pedroluna]

I have a master excel file (VP Partial P&L's -Feb'09.xls ) with about 95 different sheetss one per department. Each of these sheets have to be inserted in its own file (i.e. Marketing VP.xls, IT VP.xls etc…). So I need a macro that can take a look into this file (VP Partial P&L's -Feb'09.xls) and take each sheet per its name and insert it in the appropriate VP file. Also, if I can gvie the new sheet a different name (i.e. Feb 2009), it’d be great.

I am copying and pasting each sheet which is time consuming. I was thinking about a macro/program that can do the copying and pasting, but doing the above is a better fix.
Thank you
Pedro