VBA to open master file, modify 1 cell, recalculate, and save as based on list

[chickiviz]

Hi all,

Many time user, first time poster! Just cant seem to find code already made to get what I need and hope you can help...

I have a workbook (master) which I need to replicate many times in the same folder whilst modifying one cell and saving as using a list...

eg. In this file I need to change one cell (A10 in 'Summary') based on a list in excel then I need to recalculate the file, paste copy values the summary sheet and finally save as using the same list of numbers as the file name

I hope this is not a difficult challenge

Thanks in advance
Vic