An expert gave me help before but now have an error that I cannot fix... the formula is =SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets&"'!"&"A:X"),A3,INDIRECT("'"&Sheets&"'!"&"R:R"))) and it picks up work sheets from a defined range - but now I have added extra sheets there is a ref error.
Solved by S. Q. in 26 mins