Hi, I have a dynamic named range that i use to populate a chart. I need to now create 50 tabs, with the same chart, but different data on each sheet. I've used lookups to pull the data to populate the charts. However, b/c the range is referencing the 1st tab I created, the charts don't update...