I have a spreadsheet with 12 duplicated worksheets. The workbook has named ranges like Constant1=!$A$1 Range1=!B2:B5 and Range2=!C2:C5.

I would like to create one chart that will plot Range2 vs Range1 from Sheet1 as well as the same ranges from the other 11 worksheets.

I thought Sheet1!Range1 would work, but It doesn't. I could instead define 12 copies of every range: Range1_1=Sheet1!B2:B5 Range1_2=Sheet2!B2:B5 etc. and plot Range1_1 vs Range2_1, but there has to be an easier way than doing everything 12 times.

Thanks for any help.
Kevin Nowaczyk