Excel VBA, how to create a macro that creates a PivotTable from 1 data sheet from another workbook

[Armien7]

Hi everyone, I hope you are all doing well!

I need some help with a macro that I'm trying to make.

Every month I get a data sheet named 'Mutaties' from a few customers, which I then turn in to a Pivot Table. Tho when doing this for 30 customers.. it gets repetitive.

I'm trying to build a macro button in 1 workbook (Workbook name: 'Macro Knop voor Auditfiles', worksheet name: 'Macro Knop') that turns the data in the other workbook (workbook: 'AuditFile', worksheet: 'Mutaties') in to a PivotTable. With the following 3 filters, in the rows: 'grootboekrekeningnaam', 'grootboekrekeningcode'. And 'saldo' as values. I have some attachments for clarification.

There will always only be 2 workbooks open, 1 with the macro button (which I click on the start the macro) and 1 workbook with the data from my customer (which I like to turn in to a PivotTable). Once the PivotTable is ready I save and close it to go to the next data sheet to repeat the same process).

I hope some of you have some tips / tricks for me, I would love to hear them. It would help me out lotss!

I want to wish everyone a wonderfull weekend!

Cheers,

Armin