title: Best way to have an order sheet for every day
body: <p>I'd like to organize a spreadsheet to have one tab for today and one tab for each of the next 6 days on a rolling basis.</p>
  <p>The tabs would pull order info from another sheet which has all aggregated order dated. Ie March 17's sheet would list all orders for that date, pulling from the aggregated order tab.</p>
  <p>Is there a good way to set this up? The issue is I can't simply use =today on tab 1, =today+1 on tab 2, etc. because it needs to preserve manually added data as well formulas.
  For example, col A is order number, col B is Items, col C is 'picked (y/n)', col d is notes. Col A and B pull from the aggregated sheet and will therefore move as the date changes but C and D are manually entered on that sheet so as the date changes they won't move with it.</p>
  <p>Perhaps this is impossible on Google sheets and there is a more suitable, simple to use product you can recommend?</p>
  <p>EDIT: I've made a sample workbook here: <a href="https://docs.google.com/spreadsheets/d/1mN5XbyB4xV9WUDwZedcReoA_9VFQ0N-7VrI-gzw6WZQ/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1mN5XbyB4xV9WUDwZedcReoA_9VFQ0N-7VrI-gzw6WZQ/edit?usp=sharing</a></p>
  <p>Columns A and B move as the date changed as desired. I want to find a way to have the info entered in Col C and D move along with it.</p>