Autofilter inside pivottable

[BBos01]

Goodevening everyone,

I'm looking for some help with an autofilter inside a pivottable. All codes that i could fine are too specific unfortunately.
The data entry is in the first tab "Macro". I would like the data to be automatically filtered on "Project" in the pickinglist tab. So it should filter directly when the data in the first tab changes.

I also noticed that when i filter manually, the data starts in row 570, while it should start from the top. Maybe someone has an explanation for this as well?

Thanks in advance,

BBos

 

[BBos01]

https://1drv.ms/x/s!AmRd2gjhCCZagW94XuT1WYm3JZI2