Hi,
  1. First of all i would like to know does VLOOKUP pull information from a workbook that is closed or must the workbook be opened in order for VLOOKUP to work?
  2. Is there anyway i can make the data copy over to a different sheet before refreshing?
I posted an example Example.xlsx of the results i would like to see. If someone can help me i would greatly appreciate it. I would prefer if it's a formula not a macro since it will be on multiple sheets.
Thanks