You can put to each cell in that 8-9 worksheets where is need also put the date such formula: =Worksheet1!A1 (it's for example, actually, you must write instead Worksheet1 the name of that worksheet where you want to enter data once, and so instesd A1 in example you write address of the cell where you will enter it). So, you must write formula like this, then you can copy it to the rest of worksheets, and one time you need to format the data using format painter. If you will use this workbook weekly, just change date in the worksheet that you wrote in formula.