I'm working on a spreadsheet and need to write a macro that at the end of the day will summarize all the other sheets. I want the summary sheet to refresh each day and I also want the sheet to be linked to a pivot table that will refresh off of the new summary sheet data.

This is what I have so far. It summarizes all the sheets into one sheet, but creates a new summary sheet each day instead of just refreshing the sheet like I want. 

Please Login or Register  to view this content.
Thanks for the help!!!

-Christina