How to Automatically update data in other sheets in a workbook ?

Hi, I am new to Excel VBA

Problem - I have 3 tabsheets (All,Form461-0013,Rev01,Cost estimate). In each sheet ,i have one update button . How i can combine these "update" buttons in one single "update"button in the userform. so when you click the update button on userform. All the 3 sheets will automatically get updated !!

Please help me !

**Below codes are from 3 different sheet's Private SUB ()

'All' sheet code

Please Login or Register  to view this content.

'Form461-0013,Rev01' code

Please Login or Register  to view this content.

'Cost estimate' code

Please Login or Register  to view this content.

1.Put an update command button on the userform
2.From the userform command button sub call all three update subs

IMPORTANT... Amend the range references in your code to include the sheet.... e.g. Range("A1") to Sheet1.Range("A1")

@Andylitch: Not working!! ... using sub call 'All' sheet code and 'Form461-0013,Rev01' code working but 'Cost estimate' code not working

Refer to POST#1

Help me, please!!

Did you amend the code in the cost estimate sub to include the sheet name ?

Range("A25:A40").FormulaR1C1 = ......
to
sheet1.Range("A25:A40").FormulaR1C1 = .....

@ AndyLitch : No, i did not did any amendment to the code !!

Do I need to change to that ,#4 ?

Yes you MUST include the sheet name if you execute the code from a userform because if you don't the code will run on the visible (active) sheet instead of the sheet it was designed for.
There are two main ways to specify a worksheet :-
a) The Tab Name ............Sheets("Sheet1").Range("A1")etc
b) The Vb name...............Sheet1.Range("A1")etc
You can find the Vb name in the VBE project explorer ... The tab name is shown in brackets next to the Vb name.
I recommend using the Vb name because it's fixed and never changes.

The Form... code is OK because it specifies the sheets
The 'All' code does not - I recommend you change that to include the sheet name

Not really, no.. The speed will be much the same either way

@AndyLitch: Is this 'Worksheet_Change Event' same as Using Call function ?

For Automatically update data in other sheets in a workbook ,is it possible to use 'Worksheet_Change Event' ?

Worksheet_Change Event is triggered when a different cell is selected.