I have a workbook with about 35 sheets in it and a chart that
repeats on each page with the current data. I would gladly convert
it to a dynamically ranged chart (so I can just replicate it on
each sheet without editing the data source), but the problem is
getting the worksheet name into the range. Can someone point out
how I might do that?

Thanks for any help.