Hi,

I have a master workbook which pulls data from 12 separate worksheets each worksheet is contained within a different workbook but all workbooks are located in the same formula.

The linked worksheets are updated based on the =Now() e.g. if =Now()> date in a certain cell then run formula, if not leave blank.

This all works fine, however, to update the master worksheet I need to open all the linked sheets so that they are updated. This is a problem as it is very slow to open and close these sheets.

Is there a work around I can put in place for this? Hopefully the explanation was understandable, if not please let me know.

Regards
Tim