Each day I receive a s/s, from this data I create 3 separate pivot tables (in the same workbook). Looking to create a macro to stop the repetitiveness of this task.

How do I do this? I have recorded a macro, it works great on only on the data I used to create the macro with. When trying to use the macro on the next day data it fails.

I do not think the recorded macro, is the best option. It is a very long code. If somebody could offer assistance that would be appreciated. If you require to see sample code/data please ask and I will provide. thanks.