There's a couple of ways to do it.
First, let me slip into "teacher" mode:

How do you WANT to do it?
What steps would you go through to do it manually?
This is the logic you use to help  decide what to do.
So...
You WANT to make this work with each sheet...
You could select each sheet, then run  this macro.
Which means you could add a sub like:

sub Update_All()
for I = 1 to sheets.count
if (Ucase(sheets(I).name) <> "MACRO") then
sheets(I).select
Updates2
end if
Next I
End Sub

Now, if you have a LOT of sheets, we may want to look at
turning off screen updating in this sub and not in the other.

give it a shot and let me know how it works.