title: Google Sheets - referencing data from another sheet "DataSheet!A1:A" want to be able to import a new sheet and update that reference... best way?
body: <p>I'm not well-versed in Google Sheets or anything related to it really, but i'm doing basic google sheet formula stuff at the moment for my business, I am importing data from somewhere else and have copied over data from the import into my stats sheet using the basic copy formula</p>
  <p>&quot;DataSheet!A1:A&quot;</p>
  <p>later on, the Data Sheet will have to be updated with another imported sheet that will match in rows/columns but with new values...</p>
  <p>... How do I reference/copy over columns from another sheet, while making it easy to update with a new import later on?</p>