I have a formula
=sum(indirect($q$1&"!P7"))

When I pull the formula down to other cells P7 doesn't change.
I need it to change to reference other cells when I pull it down.

Thanks,