sheet and cell replication

Hey,

Im looking to create a macro that will use 'Sheet 1's format and copy it into a number of other sheets with sheet names and a specific value in one cell.

Basically I am sent a template each month with all the formulas set. I need to replicate the sheet (copy) into about 100 identical sheets. The only difference is a reference in cell F150 which is used by oracle to populate the sheets and the sheet name. The information for both the sheet name and the cell reference are identical to the cell reference and sheet name from the previous month. (The change is in the template I am sent which is all pre-formatted and just needs to be replicated with the string from cell F150 and the sheet names).

So very mundane and time consuming, should have a very simple code. Havent been learning VBA for long but hoping my programming xp will help speed the whole thing along

Thanks for the advise and help!