excel - Copy multiple sheets to one master sheet with today function

Question

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!

Answer 1

等待大神答复