when updating sheet1 a1:a100, auto updates sheet2 a1:a100.

I'm using =Sheet1!A1 and auto filling it down on Sheet2 in the A1 cell but Sheet2 will not auto update if I insert a new row in Sheet1. Any ideas on how to fix that? Thanks guys/gals!

I found this on here

Option Explicit

Sub Worksheet_Activate()
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
End Sub

Sub Worksheet_Deactivate()
ActiveSheet.Select
End Sub

Instructed to insert it in the "view code" prompt when you right click on the sheet tab at the bottom.
I works, I just enter in my sheets I want to be updated at the same time the main sheet is updated into the array in the formula (to include the main sheet as well). Though I do not need my sheet2 recieving updates from sheet1 in any other column but A. Is there a way to specify in the array part of the code/formula to say only update sheet2 when column a is updated in sheet1?

That's what I'm talking about. Very Cool. Thanks man!