I have a big data dump that gets refreshed. From this data dump I create a few pivot tables. When I record a macro creating pivot tables it doesn't work the next time because destination/sheet name is no longer the same sheet. Please help creating a macro to create pivot tables. Attached is my sample data dump