Could you just link the cells? So in your second sheet have A1 be =Sheet1!A1 and A2 be =Sheet1!A2 and so on? Do they need to be dynamic? Copy and pasting would be easier. You can highlight (control click) multiple sheets to make changes to multiple sheets btw.