How to auto update charts from new sheets.

Hello all,

I get weekly updates for a report that I generate. The data is always in the same format and location, and each new sheet is named the date it was generated on.

Currently, I am manually re-referencing the links to the new sheet every week. I would love to know if it is possible to create a toggle that would allow me to bump everything over to the new sheet.

Thanks for all the help in the past.

David