Every month I import a table into Excel from Access. Each time I do this, the table has 1 extra column on the right for the new month. Sometimes there are new rows as well, but not always. Excel accommodates the new table by pushing current columns to the right and current rows down. This works great for the current sheet. But there are other sheets in the workbook that need to have the same layout as the one I'm importing the table into, and ultimately I would like them (the other sheets) to automatically be updated when I import the new table. The icing on the cake would be to have the new columns in the non-importing worksheets copy the formulas to their left, and have the new rows copy the formulas in the rows above them.