Ask Admin/Mod to move your thread to appropriate part of forum: Excel Programming / VBA / Macros becuse your problem is not a PivotTable but multiple pdfs.