I want to set up a series of worksheets in which a new
worksheet can be added (through a nice little macro) and
the new worksheet has specific content already included on
it (preferably taken from another worksheet). How do I:
a. make this happen, b. make this take the content not
from a master sheet but from the sheet created say the
week before?

Does this make any sense?

Thanks

S.