Is it possible to use a macro to refresh data in the active workbook (book 1) from a table of data in another workbook (book 2) which will also need refreshing from a third workbook (book 3)? that is, cause book 2 to refresh when the the data in book 1 is refreshed? I am trying to get around network permissions which lock certain members of my team out of a core finance drive.