i use concatenate here

set up a sort list (using data/sort/custom list)

then start the list of the sheet names

then =concatenate("='",b2,"!$B$2")

then copy, paste special - values

type 1 in c1 copy,

then.... select full range, paste special again and select 'multiply'

this should force the cells to calculate

hope this helps