could someone tell me if this is possible, if so how to go about it.

worksheet (named 'master' ) in a workbook, (named 'blank weekly overtime')

everyweek this workbook will be copied and renamed to 'weekly
overtime+weekdate' if any data is changed on the master sheet, the 'blank
weekly overtime' workbook will be changed to match it. this would of course
ensure all future copies are kept updated.

I do not wish to have this master sheet kept in a workbook of its own and
have all other workbooks linking to it, because this would mean all previous
copies would also be changed.

hope that makes sense, and thanks for your time,
Steve