title: Refreshing Excel data from an MS Access query without wrecking references?
body: <p>We have an Excel workbook that has a lot of summary sheets and such that all reference a core "Data" tab that we copy-and-pasted from an MS Access query. This data is referenced via several SUMIFS functions, a few PivotTables, and we have a Name associated with the columns of this tab, etc.</p>
  
  <p>But we'd like to refresh this data regularly without wrecking everything. Is there VBA code that would accomplish this from MS Access? Ideally what it would do is clear the cells of the Data tab and then paste the query output there instead. I initially considered <code>transferspreadsheet</code> but this seems to replace entire sheets at a time and would destroy all these references.</p>
  
  <p>Is there a "safer" way to refresh/export this data to the Excel worksheet?</p>