Dynamic Functionality In Workbook

I have sheet1 along with three columns as below

Result column will show the result after sum ** column A & B

[Code] ......

This is simple that i will add this formula =A2+B2 in Result column cell C2.

But i want to perform this addition action on Sheet2 and return the result in column C2 ** Sheet1.

What formula should be populate in Result column ** Sheet1 that could catch addition formula from Sheet2 dynamically and display the result ** column A & B in Sheet1 .

And what type ** formula should be use in Sheet2 to add two columns dynamically.

The same concept that we are using in any functions like as below:

Sub Function Plus (value1 As Double, value2 As Double)
Plus = (value1 + value)
End Sub