title: Reference an excel sheet from another workbook without copying the sheet
body: <p>Im wondering if it's possible to reference an excel sheet from another work book without making a copy of that sheet?</p>
  
  <p>The situation : I have some very large worksheets filled with various data, but i don't want to keep a copy of them open in my workbooks because  while each workbook uses the same data source, they're slightly different. </p>
  
  <p>I have a vba routine that takes this data and creates input files for other codes, vba expects this data to be available on the defined sheet names.</p>
  
  <p>Is it possible to make either excel or vba to know that when i request worksheet("Example_1") it instead knows that i mean example_1 from a different workbook?</p>
  
  <p>Thanks</p>