Excel automation without using macros

Hi

I am not an expert in excel...I actually want to automate date in all the worksheets (8-9 worksheets ) once I enter data in the 10 data worksheet. As of now I have to manually go to each and every worksheet, refresh and format the data using format painter.I have to work on this report weekly

Any help will be appreciated.

Thanks

Excel automation without using macros

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.