complex macro needed for pivot table

Dear Excelers,

Perhaps someone is willing to help solve my work task by writing a suitable macro!
I would like to automatically change the filter and show data before a date in a few pivot tables.
I have looked up how to do this with coding, but think it is quite a bit above my understanding.

Essentially it should be a looping macro so that after all the actions for row 3 are complete, that it starts with row 4, then row 5, etc.
There will be a lot of data so untill the macro hits an empty cell.

step 1. all the pivot tables to be in Z->A order so that the latest dates are on top
step 2. the date in A3 to become the date in all the pivot tables before which all data is shown
step 3. the content of B3 to be in sheet2B1 and also sheet2N1
step 4. the content of C3 to be in sheet2H2 and also sheet2N2
step 5. the values from sheet 4 (which are based on the pivot tables) to be placed in the corresponding rows in sheet 3, so D3:F3 and then D4:F4
then repeat for the next row

perhaps there should be a refresh of the Pivot table somewhere? I don't know if that is necessary.