Here is a static formula for the Series "Loads"

=SERIES(Hypo!$I$2,Hypo!Labels2,Collect.xls!Loads2, 4)

This only graphs what is on the Hypo page. (By the way, why is the last
Hypo subbed with Collect.xls?)

I need instead to switch between 3 pages. I tried the following:

=SERIES(INDIRECT("'"& $O$2 &"'!$I$2"),INDIRECT("'"& $O$2
&"'!Labels2"),INDIRECT("'"& $O$2 &"'Loads2"),4)

and Excel simply says That is not a valid function. The end.

Why doesn't this work? Each individual piece returns the right information.

I appreciate any help you got. Have a great day!

Arlen