Pivot Table Loop Through Multiple Workbooks

[reddsable]

Hello, how can I name a pivot table dynamically? I am trying to create a Pivot Table in several workbooks with the name "PivotTable1" , in the first workbook it works fine but then it is telling me that the name was taken. Can I name the Pivot Table "Pivot Table" & int? int being by file in a folder? if yes, what would be the appropriate code? thanks!