I want to be able to create a pivot table at the end of every month that is automatically generated. All the data for the pivot table will be on a single spreadsheet. The format will stay the same every month however the emphasis is on it being generated automatically on the very last day of the month vs the current procedure where I have to manually generate it.

Does anyone have any ideas or recommendations on how to achieve this.

Any help would be much appreciated.

Thanks