I have a workbook which has financial forecasts. Since the forecasts are always changing I need a macro that when executed will

1) Copy the value from the following cell "='Project Finance View Summary'!J25"

the cells range from ='Project Finance View Summary'!D19:AD33


2) Paste in sheet "Base Line Historical" with date time and author

I would like to have this looped so i can keep a historical log of each time the base has been saved. An option to overwrite the last save would be a nice to have feature.