I have a spreadsheet with a total of 7 tables. I need to be able to rotate the data in these tables down one table if I add a new table. I am using this as an application and we recieve a new set of data (in a table) every month. We keep 7 tables at a time and each table has significant information. I am trying to stear away from using a macro. I have got the data of the 7 tables to rotate using a nested IF statement conditioned on a cell that I enter a number 0-7 however I cannot add the new table without changing the data of the other ones. I know there is some way to accomplish this and it has really proven to be challenging.