title: Excel - Automatically change input cell value and export output cells to new workbook
body: <p>I have a spreadsheet where I can enter a reference number and Excel generates a table based on the data tied to that reference number.</p>
  
  <p>Rather than enter each reference number individually and copy the resulting table manually, is it possible to automatically iterate the process of entering the reference numbers (from an existing list) and exporting the results separately?</p>