For the first question i'm not sure how this works out in your example.

You may need to use $C1 rather than C1 in the formula

For the second question apllication.run followed by the name of the
procedure
I would then assign Macro3 to a button


Sub Macro3()
Application.Run "Book2!Macro1"
Application.Run "Book2!Macro2"
End Sub