First of all, I am tracking data via a SQL database that loads data every minute. I query this data and then create worksheets in Excel. The data is then formulated to give me information in an alarm type setup. A report must be drawn from this data every 24 hours. I have the formulas on each sheet and then I copy them into a report sheet. How do I move the updated data down the worksheet as each interval is updated.? How do I maintain the current values of each cell as the data is moved? Please see attached file.