suming using Vlookup across multiple worksheets in the same workbook

[Nelboy]

Dear all,

I would be grateful of some guidance

I am trying to update some formulas in a workbook. our portfolios now have split mandate so have different assets and thus the previous formulas need to be updated

previously as all of the portfolios where the same I have been using

 =sum('*',!z9)

''''etc etc etc to cover the 15 assets held

 =IFERROR(VLOOKUP($B2,INDIRECT("'"&C$1&"'!$b:$z"),23,FALSE),"")

'''' can use this to reference the individual portfolio with the sheet name is in cell C1

 =IFERROR(SUM(VLOOKUP($B2,INDIRECT("'*'!$b:$z"),23,FALSE)),"")

''' I was hoping the above would be a solution, but defaults to the error response (or #REF, without the IFERROR)

thanks in advance