How do I get a macro to work across multiple worksheets?

[BBTrekkie]

I use the following macro to update the inventory amount to a specified cell that is connected to a master sheet that shows me the amount in inventory for each item. Right now I have to go to each sheet and run this macro individually which is time consuming.

Anyone know how I can get it work on all the sheets at once? Each sheet has a name based on what it is inventory.

thank you

Range("C1").Select
Selection.End(xlDown).Select
Selection.Copy
Range("E1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

[anilsolipuram]

this should work

try this macro

Sub macro()
For Each w In Worksheets
w.Select
Range("C1").Select
Selection.End(xlDown).Select
Selection.Copy
Range("E1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Next
End Sub