Change the "weight" cell that's in summary workbook and the macro runs by itself for closed workbooks.. I guess, I'm trying to save a step of pressing the key for macro but now that I think about it...it's not really needed.

So with that code, if I change the weight cell that's in summary workbook and run the macro, other closed workbooks should run in background and update it's values...and hence I should see the summary workbook pull new data. Am I correct?

If so, I'll definitely give it a try tonight. Thanks!