As part of a project, I need to create a sheet which contains multiple tables(a template if you will) and copy it to create one for each month. Each month’s starting numbers are feed by the previous months ending numbers. Is there any way to automate this process without manually changing each link reference manually so that any number of copies could be made? Can this be designed into the first worksheet so that copying it using, perhaps a naming structure similar to sheet1, sheet2 etc… Any thoughts on approaches to this would be helpful.

Thanks
Scott