I am in need of a VBA code that:
- can copy four different worksheets (with data from four different dates, which are every week the same: excel function today(), today()-3, today()-7, today()-10) into one master sheet of the same workbook
- it also needs to integrate the correct date worksheet needs today(), worksheets 2 needs today()-3, worksheet 3 needs today()-7, worksheet 4 needs today()-10
- the data of the four worksheets will be changed weekly and the code should adapt to this
I am grateful for any help or tips on this!
