Hi, I am currently creating a spreadsheet for a weekly stock take at my work.
I want to know if Excel can automatically create new sheets within a workbook that will be dated as the monday of each week.
Also, can I make it so that the final totals in the last colum of one sheet(one week) become the starting totals for the first colum in next sheet (next week)

I can work excel, but i'm not computer genius..thanks for your help